Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index not match on a line where no ref
Message
From
20/06/2007 07:58:08
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Title:
Index not match on a line where no ref
Environment versions
Visual FoxPro:
FoxPro Dos
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01234450
Message ID:
01234450
Views:
59
Hi guys

This old fpd26 system I have to maintain. It has been working fine then suddenly the user got an error:

Index does not match the table. Delete the index file and re-create the index (Error 114)

at line 69.

Now line 69 had nowt in it but there have been changes to the prog since the last compliation so I couldn't trust that.
So I recompiled the prog and ran it. Now the error's on line 72 which is:
sele 0
use bankhols order 1
<--------------------------- line 72
sele 0
use xvalue
the same line as before!!!!!!

So obviously the table bankhols was suspect. But I ran the same line "use bankhols order 1" in the IDE and got up the table OK.
Using modi stru (in FPD26) I disappeared the little up-arrow next to the Date field in this table, the indexed one, to get rid of the index.
I was going to physically delete the .cdx in explorer but this action seems to have done it for me (I couldn't find the .cdx).
Then I put the arrow back in to create the index and saved. The usual "x records indexed" message came up and the up-to-date cdx file was there in Explorer.
I opened the table in the same way and browsed it OK.
Closed the table and ran the system again

Got the same error.

Anyone got a clue what's going on here? PS I did open and browse all the tables USEd around this line just to make sure it wasn't one of them.

'ppreciate it

Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Next
Reply
Map
View

Click here to load this message in the networking platform