Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to FIX error 114 ?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00806721
Message ID:
00806910
Views:
22
Hi Cyrus

I just delete the CDX file and then re-index the table:

delete file mytable.cdx
Use mytable exclu
Index On....

Simon


>The Error 114 which is "Index Does Not match table, delete index.." is sort of a Chicken and Egg problem.
>
>If I delete the .CDX file first, then I can't open the FILE, since vfp will issue the error: "Can't find CDX file".
>
>If I try to OPEN the file first, so that I can issue the command DELETE TAG ALL, I still have the error 114, when I try to open the file!
>
>The following code of course works when the INDEX is NOT corrupted. But, it is worthless when the INDEX does not match...
>
>USE session_mgr EXCLUSIVE && I get the error here and can't open the file.
>DELETE TAG ALL
>ERASE (p_data + '\session_mgr.cdx')
>INDEX ON STATION TAG STATION COLLATE 'MACHINE'
>USE
>
>Any suggestions ?
Simon White
dCipher Computing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform