Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record is not in index (Error 20) Cause?
Message
From
27/01/2024 10:07:18
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:
01687583
Views:
35
>Here are key details:
>
>1.) The cause of the index becoming corrupted or out of sync with table data remains unknown.
>
>2.) The table is created just a few lines earlier, and the index is a CDX index tag. As far as I know, CDXs are typically maintained automatically.
>
>3.) Despite the Error 20 being thrown, the output CSV was generated, and several thousand rows were successfully written to the file. Presumably the issue arose when FoxPro encountered the record with the corrupted index entry.
>
>4.) Upon inspecting the rows in the output CSV (both the shortened version before implementing REINDEX and the full one created after adding REINDEX), I haven't identified any anomalous data that would explain the occurrence of the problem.
>
>5.) I still need to examine the source table's data, but I'm currently running a test, so access to the data is temporarily unavailable.
>
>I hope this provides a clearer picture of the situation. If you have any insights or suggestions, please feel free to share.
>
>Thanks again!

Probably some timing / caching issues?
Is the index active, or will the export work with SET ORDER TO as well?
If no, try to create the INDEX after export.
Is this a table or a cursor? Just out of curiosity, why the table? It sounds like you create a table for later export? But this would mean to clean the OS?

And again, I would use a SQL SELCET to create the cursor and export this. You can order while creating, so you do not depend on SET ORDER. (For me, tables are just storage, any work is on cursors create via SQL SELECT, mostly by CA. Index is only to optimize SQL - and on the front end, so user might sort the grid on own need.)
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform