>>Hi all -
>>
>>I don't think I've ever experienced this error in any of the apps I've been involved with. Currently working on a very old VFP app running under VFP 8.0 (Version 08.00.0000.2521) and encountering this error when a PRG attempts a COPY TO (lcRptFile) FIELDS &lcFldList. TYPE CSV command.
>>
>>- This code runs all the time; not sure why this particular import is triggering the issue.
>>- The table in the current work area is created by the same PRG, and the index is a CDX (so makes it harder to understand how data may have changed in the DBF row but the index is not updated).
>>- If I suspend, then retry the command, it works! (So I can introduce code to catch the error and retry. Obviously.)
>
>What happens if you put a "GO TOP" command just before the "COPY TO" command?
>
>>- This "feels" like a buffering / latency problem to me.
>>
>>Clearly we're missing at least one SP for VFP 8, and it could be that or VFP 9.0 would not throw this error. That said, upgrading VFP is not an option at this time.
>>
>>Any thoughts?
>>
>>TIA!
Yeah, that's a good idea. I'm going to wrap the call in a TRY/CATCH and re-try the COPY once or twice and see if that solves the issue. While I'm in there won't hurt to move the record pointer and see if that solves the issue. Thanks.