Search results for query: *

As I told... I have not a crystal ball Yes, IFNULL() for MySQL/MariaDB is right function. Ad Moth table - check if your MySQL/MariaDB version knows Recursive CTE.

Because I have not a crystal ball and I do not know your table's structure then sql command can be: SELECT Customer.Code, Customer.Name, Month.Name S MonthName, NVL(SUM(Entry.Amount), 0) AS Amount; FROM Customer INNER JOIN Month ON 0=0; && month is cursor with 12 records (for each month)...

VFP (3-9) has not many functions for releasing unused memory SYS(1104) - free data cache for data area API SetProcessWorkingSetSize(...) IN kernel32 - free unused memeory

see to help: https://www.vfphelp.com/help/_5wn12pzo3.htm

Hi, You can use smaller font (6) for text field NAR1 - NAR6 or sets trim mode to "Trim to nearest character"

It's not bug of VFP, but behavior at using GDI+ for rendering text with Gdiplus::StringFormat::GenericDefault . https://stackoverflow.com/questions/118686/measurestring-pads-the-text-on-the-left-and-the-right https://theartofdev.com/2014/04/21/text-rendering-methods-comparison-or-gdi-vs-gdi-revised/

md5.fll and vfpencryption71.fll has functions for calculating file's hash. md5.fll use "modern" API for file access. vfpencryption71.fll use "old" 16 bit API for file access.

1) use ADODB.Stream - https://www.tek-tips.com/threads/open-file-as-unicode-utf-16-and-save-as-utf-8.1818112/ 2) use API - https://github.com/VFPX/Win32API/blob/master/samples/sample_346.md DECLARE LONG CreateFile IN kernel32.dll STRING @, INTEGER, INTEGER, INTEGER, INTEGER, INTEGER, LONG...

How to change the display language for non-Unicode programs The window: https://activenetwork.my.salesforce-sites.com/hytekswimming/articles/en_US/Article/Setting-Language-for-Non-Unicode-Programs --- Do not check UTF-8

FoxPro for DOS has simply way how to shoe window inside another window: SHOW WINDOW [window_name] IN WINDOW [window_name]. This old command works within VFP forms too.

Yes, it's possibly, but how as Tom... Why?!? PUBLIC m.poFormMain, m.poFormChild m.poFormMain=CREATEOBJECT("_formMain") m.poFormMain.Name="MAINFORM" m.poFormChild=CREATEOBJECT("_formChild") m.poFormChild.Name="CHILDFORM" SHOW WINDOW ("CHILDFORM") IN WINDOW ("MAINFORM")...

foxup: Do you use VFP 9 or VFP Advanced? Second is driver type You can verify if you have the correct driver by running printmanagement.msc and navigating to Custom Filters -> All Printers. - Column "Driver Name" contains driver which printer use. - Custom Filters -> All Drivers: Show column...

A member dmDeviceName is a buffer of 32 BYTE or 32 WCHAR

Note... DEVMODE struct has a member dmDriverExtraData - This field can contain implementation-specific printer driver data. Its size in bytes is specified by the dmDriverExtra field. This binary data not possible share between printer drivers.

Are you sure, so ODBC drivers on both PC are same? Please, compare version and file size.

Why?!? * textbox keypress event IF NOT PEMSTATUS(_Screen, "oDT", 5) *SET PROCEDURE TO (m.lcPath+"..\src\DTCLASS.prg") _Screen.AddProperty( "oDT", CREATEOBJECT("_DATE")) _Screen.oDT.AutoFillDate=1 ENDIF This.Value=_Screen.oDT.ToDate(This, This.Text)

Here is class what you need: https://github.com/MJindrova/dtclass

https://www.foxite.com/archives/merging-rows-into-one-0000488434.htm

Hi, Detail band, in your report, has height 50.8cm. This is very long band. You must split detail band to more detail bands or detail band with more temporary groups. How you want print band with height 50.8cm to A4 paper?!?

dBASE V file it's a Paradox DB file and it's incompatible with FP/VFP DBF.