>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only