Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SOS: SET KEY inconsistent behavior
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
SOS: SET KEY inconsistent behavior
Miscellaneous
Thread ID:
00006376
Message ID:
00006376
Views:
96
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
J. Luis Santiago Rodríguez.• CADIS • E-mail: jlsantiago@iserve.net.mx• Ciudad de México.
Next
Reply
Map
View

Click here to load this message in the networking platform