Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SOS: SET KEY inconsistent behavior
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00006376
Message ID:
00006380
Vues:
44
>OK, i hava a couple of free tables in a master - child relationship. If i type from the command line (both tables opened):
>
>SELECT ChildTable
>SET ORDER TO RelationIndex
>SET KEY TO ParentTable.RelationField
>GO TOP
>BROW
>
>Every thing works fine. But i have a form with this 2 tables (among others) added and if i run the same code i get the error "Table is not ordered" when the GO TOP is issued. Even more weird, cheking the table visually it seems like been ordered (the little arrow is shown), but if i try to browse it, i got an:" INDEX internal consistency error", and VFP (3.0) fully closes itself (i have tryied reindexing).
>
>Does anyone have any ideas about this strange behavior ?, it seems to be related to the SET KEY command.
>
>TIA,
>
>J. Luis

Delete the indexes and build them again. Not with Reindex.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform