Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record is not in index (Error 20) Cause?
Message
 
To
25/01/2024 12:54:52
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01687574
Message ID:
01687580
Views:
53
>>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.)
>>- 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!
>
>Quick'n'Dirty approach: Would it help to SQL SELECT .. INTO CURSOR xxx NOFILTER and COPY TO from that?

Another good idea... If my other attempts don't pan out I'll circle back to this one. Thanks!
________________
_____/ Regards,
____/ al

___________________________________________
www.jcn-associates.com
Visual FoxPro Database Application Development and IT Project Management
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform