Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error Index Does not match the table
Message
From
27/01/2023 09:33:09
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01685987
Message ID:
01685988
Views:
47
Likes (1)
>Hi,
>
>Today while reviewing the error log of one of the customers I see the following couple of errors:
>
>Failed TABLEUPDATE() of WORK_HIS
>Index does not match the table. Delete the index file and re-create the index.
>
>
>This customers is using a SQL Server database.
>
>I have never seen this error.
>1. What would cause it (as I understand in SQL Server)
>2. How do I find out which Index is the problem (the file has several indexes)
>3. How do I delete and reindex a SQL Server table?

Haven't had this one since 1994.

Somewhere along the way you indexed a cursor and gave the index a name, which became also its filename. Your app crashed, or you did this in two places at the same time, with different cursors. The index was found on disk, and its name now matches the alias of something else. Bang.

If you mean to name a cursor's index, use sys(2015).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform