Recent content by JackTheC

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.