Search results for query: *

What about the command Blank field <fieldname> BLANK Command BLANK [FIELDS FieldList] [DEFAULT [AUTOINC]] [Scope] [FOR lExpression1] [WHILE lExpression2] [NOOPTIMIZE] [IN nWorkArea | cTableAlias]

Sometimes reducing the amount of memory will help. That worked in VFP3. A long long time ago.

I had the same thing after I included a .h file with #Define instruction in .prgs (with #include command) and forms (through menu). After I removed these all was back to normal. This problem occurred in several of my projects. I couldn't reproduce in a simple example so there might be a...

There is another way to create an object reference to a specific version of Excel. You can't use Excel.application.10 or Excel.application.16 because the have the same CLSID so they will start the same version. But there are also Excel.Sheet.5 or Excel.Sheet.8 or Excel.sheet.12 ProgIDs in the...

The -Embedding option does not work with Excel. The loMyComObject is not properly generated. The next lines gave errors. In the registry you can see that only /automation is used by MS. I use /N2 to prevent the splash screen of Excel. This works fine. Starting Excel through Wscript.shells run...

Chris, that worked. Thanks. I altered the code a bit and added the normal CreateObject for the standard version. Now you see both ways next to each other. Local lcRun, loMyComObject, EXCEL_CLSID,ea EXCEL_CLSID="{00024500-0000-0000-C000-000000000046}" * Forced version (10) lcRun = [Run /N2...

Since there is no elegant way to force the 10 version, I opt for the (programmatical) name swap of the LocalServer entries. Then I can set 10 or 16 as the default for CreateObject('Excel.application') and still use the 10 and 16 version manually.

Chris, because HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Application.10\CLSID HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Application.16\CLSID have the same value, they have the same ProgID since the CLSID determines the ProgID when you use CreateObject('Excel.Application.##') ProgID is one of...

I can only add that version 10 is 20 years old... I don't know what you mean by 32 bits version of the registry. Regedt32 and regedit have the same content. HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{00024500-0000-0000-C000-000000000046} and...

No Chris, I installed version 10 and 16 on several PC's the result is always the same. Same CLSID, and the entry in LocalServer32 is the last installed version whether it is 64 or 32 bit version of Office 16. But only for Excel. AFAIK Word 16 has no automation entry.

Thanks Mike, I just wanted to add that I looked in the Registry and i saw an entry Excel.Application.10 . Then i tried that number .10 (in CREATEOBJECT("excel.application.10) but still the last version (16) was opened. Excel.Application.10 and .16 had the same CLSID referencing to the same...

I have 2 versions of MS Office installed. When I use createobject("excel.application") the last version is opened. But I want the previous version to be used for Automation. How to specify the version of Excel (or Word) to be used for Automation? When I uninstall the last version, the previous...

How about something like this: In the main program or in the Init of the form you put: public norows norows=0 In the main program you create a function or procedure: PROCEDURE MYFUNCT norows=norows+1 return 0 && or other value depending on.... ENDPROC In the grids column1 object you set...

Yes Klaus, you can. In the properties of the column or columns you can set the DynamicBackColor. I always do that with a function like "mycolor()" . Enter mycolor() in the DynamicBackColor property without the " ". Then in the main prg make a procedure (or function) to determine this...

Do you mean the variable T changes unexpectedly? I had that 25 years ago already. T seems to be used/changed by the VFP system. Since then I use TT instead of T and never use single letter variables anymore.

NicolasALLANO : Like I said, do a manual installation of Curl files for Win7 and Win8: https://curl.se/windows/ (look at the Bin folder of the Zip file) By the way: I added another parameter in the Curl command: "curl -L -s --ssl-no-revoke -o " I had one situation (pc or server) that gave...

I made a similar DPI/Scalable program and that one has to be called from within each form's Init event telling the form to scale all objects. If you don't, the existing form doesn't know that it should scale. I guess Atlopes solution has the same requirement. But I don't know, I don't scale...

I can think of only one related discrepancy between 32 and 64 bit. And that is if you install some things manually: System32 folder on 32 bit is now Syswow64 folder on 64 bit Windows. If they put stuff in the system32 folder it probably can't be found. As Capri already said VFP6 works just fine...

As I said the passing of parameters can be simpler especially to a "VFP.exe". But not all programming languages can accept multiple parameters. AFAIK a "VB6.EXE" can accept only one command line argument and you have to split that one into individual parameters using VB's split function. You...

I second the solution of creating your own Select printer form with a ListBox of printers but it is possible to manipulate the Printer Dialog of getprinter(). You can reposition it on your screen and make the form smaller or larger. And you will be surprised that the form contains actually more...