Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compound index with two integer fields
Message
From
05/04/2000 12:15:05
 
 
To
04/04/2000 17:51:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00355330
Message ID:
00355742
Views:
27
Hi, Andy...

Use BINTOC(). I've run into the same issue, and BINTOC does the trick.

So you'd have INDEX ON BINTOC(IntKey1) + BINTOC(IntKey2) TAG Whatever

(And obviously, any seeks into this tag would have to be something like

IF SEEK(BINTOC(m.IntKey1) + BINTOC(m.IntKey2),'Table','Tag')
...

Hope this helps.
Kevin
Previous
Reply
Map
View

Click here to load this message in the networking platform