General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Occasionally, in our application,(VFP5) some of our clients receive error message 114 (Index does not match the table. Delete the index file and recreate the index). We have tried two ways to solve this programmatically. First, A DELETE TAG ALL command will delete the .CDX file, but only if the table is open (and we can’t open the table because of error 114). Secondly, we’ve tried to use the DELETE FILE command to delete the .CDX file, but since the table has a primary key, when we attempt to open the table, we receive the error “Primary key property is invalid; please validate the database
What’s the best way to open a table in this situation so that we can subsequently re-create the corrupted index? Our re-index routine is fairly complete, in that it creates all the necessary indexes, persistent relations, and re-creates the RI code – it’s just that we can’t get the table open without doing it manually in VFP.
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