Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index Bug in VFP9, SP1???
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Index Bug in VFP9, SP1???
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01079481
Message ID:
01079481
Views:
72
Is this a bug? I can reproduce it at will.

Table has 3 fields:
---------------------
k_seqno - autoinc intiger
k_memo - intiger
textln - 65 byte chr.

1 index - on k_memo (I forgot to index on k_seqno.)

If I open the table with:
use bsmemo order k_seqno
I get no error message but show status shows that only the k_memo index exists and the Master Index is set to k_memo. I assume I should have gotten an error on the use command since the k_seqno index does not exist. Worse, the index is set to the wrong field. This just cost me a few hours of hair pulling.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Next
Reply
Map
View

Click here to load this message in the networking platform