Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index not match on a line where no ref
Message
De
20/06/2007 07:58:08
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
FoxPro 2.x
Titre:
Index not match on a line where no ref
Versions des environnements
Visual FoxPro:
FoxPro Dos
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01234450
Message ID:
01234450
Vues:
58
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform