General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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.
Hi Michel,
(Long time no speak!)
I've missed all other conversation on this and I'm too lazy to go back and look, but....
I always approach mystery error messages like this by asking myself "How would I cause this if I wanted it to happen?"
There's always a way to cause the exact message we see. I know I could cause it with an index on a UDF(). Is that involved? How else might we cause this message if we wanted to give someone nightmares?
Something about the index expression is different when you use it from an environment completely outside the VFP environment. What is it that's different?
Dan
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only