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.