Re: Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5

2021-04-09 Thread MB Software Solutions, LLC
The lcDocumentsPath code. On 4/8/2021 3:44 PM, Frank Cazabon wrote: Hey Mike, what exactly worked? On 8 April 2021 13:34:30 GMT-04:00, "MB Software Solutions, LLC" wrote: Thanks, Frank and othersthat worked. On 4/7/2021 8:52 AM, Frank Cazabon wrote: Hi Mike, have you worked this out

Re: Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5

2021-04-08 Thread Frank Cazabon
Hey Mike, what exactly worked? On 8 April 2021 13:34:30 GMT-04:00, "MB Software Solutions, LLC" wrote: >Thanks, Frank and othersthat worked. > > >On 4/7/2021 8:52 AM, Frank Cazabon wrote: >> Hi Mike, >> >> have you worked this out yet? >> >> On my Windows 10 PC, this line: >> >> SYS(5) +

Re: Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5

2021-04-08 Thread MB Software Solutions, LLC
Thanks, Frank and othersthat worked. On 4/7/2021 8:52 AM, Frank Cazabon wrote: Hi Mike, have you worked this out yet? On my Windows 10 PC, this line: SYS(5) + ADDBS(GETENV("HOMEPATH")) + "Documents\" gives me the correct path, however, maybe the sys(5) is returning the incorrect

Re: Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5

2021-04-07 Thread Frank Cazabon
Hi Mike, have you worked this out yet? On my Windows 10 PC, this line: SYS(5) + ADDBS(GETENV("HOMEPATH")) + "Documents\" gives me the correct path, however, maybe the sys(5) is returning the incorrect drive? Possibly the documents folder is not in the same folder as your default drive?

RE: Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5

2021-04-06 Thread Richard Kaye
The end of my day is coming and I'm getting distracted. Here's a little fun bit I wrote a while back to get a bunch of potential values for the SHSPecialFolders API call (sanitized for your protection, provided as is, no guarantees...): ** * Program:

RE: Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5

2021-04-06 Thread Richard Kaye
I'd look at using Win APIs to get that path. SHSPECIALFOLDERS in the vfp2c FLL wraps that for you. SET LIBRARY TO vfp2c32.fll m.specialPath=[] ?SHSPECIALFOLDER(0x0005,@specialPath) ?m.specialPath Some Windows API header file has all the values for that first parameter. -- rk -Original

Re: Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5

2021-04-06 Thread Gianni Turri
This error is thrown for an invalid path. Instead of SYS(5) + GETENV("HOMEPATH") you should use GETENV("USERPROFILE") that returns drive + path. SYS(5) returns the current Visual FoxPro default drive than has nothing to do with the HOMEPATH location. In some installation they probably are the

Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5

2021-04-06 Thread MB Software Solutions, LLC
I get this error when executing a COPY TO TYPE XL5 line in a program designed over a decade ago: /OLE error code 0x80030003: Unknown COM status code. / Interesting. I remoted into the guy's computer.  He said it's a fairly new laptop (3 months old?) and it's version is 2102 (Build