Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index and set key problem
Message
From
03/07/2001 11:30:49
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Index and set key problem
Miscellaneous
Thread ID:
00526319
Message ID:
00526319
Views:
51
Background: Single free table with an index of employee number, company, and code, all character.

Problem: When set key is issued in program an error of "Table has no index order set" although there is an order set.

One particular record with an employee number of 134 is where the problem is. Error occurs on "set key to variablexxx" which is the stored values of employee number and company. Changed the employee number to several different values and all was ok.

In doing a little research the number 134 is also used for the f12 key. Have tried scattering and gathering record to same recno, different recno, and creating a totally new record all to no avail. However I can reassign the offending record by changing to a different employee number and that works. So it would seem it's not a problem with record corruption but something to do with that number itself.

Any help would be GREATLY appreciated.

TIA
Brett
Next
Reply
Map
View

Click here to load this message in the networking platform