Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index does not match in OleDb
Message
 
 
To
22/09/2006 00:24:12
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01153721
Message ID:
01156374
Views:
26
>This situation is getting annoying. I got this message several times again today. This simply doesn't make any sense. Am I the only have having that kind of problems with the OleDb provider?
>
>The message again is "Index does not match the table. Delete the index file and re-create the index.".
>
>The data is ok. I however don't take any chance and reindex the related tables when I have this message by removing all the tags and recreating them again. If someone would have any idea on what could cause such situation with the OleDb provider, that would be greatly appreciated.

Do you have indexes that may depend on system settngs? What functions do you use in your indexes?

For instance, there was a thread in another forum, that someone used DTOC without second parameter in the index. I know you would not use such index, but just in case.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform