Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Integer indexing doesn't fly so well
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01470116
Message ID:
01470137
Views:
60
Yes, Sergey, you are absolutely correct. At first, it seemed that the numbers lined up, but they didn't so I tried the BINTOC() function and it worked perfectly!

Thank you!

Cecil

>Your index is no good because
>5+1 = 4+2 = 3+3 and so on
INDEX ON BINTOC(groupid) + BINTOC(lineitem) TAG grpqteline
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform