>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement