Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compound index with two integer fields
Message
From
05/04/2000 23:42:34
 
 
To
05/04/2000 19:45:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00355330
Message ID:
00356076
Views:
20
>...you would have a key of 0123400456 if you lead padded or 1234045600 trailing

The leading zero version would work, but you wouldn't want the trailing zero version, because in your example above you could not distinguish between 1234 and 12340. They both would be represented as 12340.

Anyway, I think Andy got good suggestions to use BINTOC(f1)+BINTOC(f2).
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Reply
Map
View

Click here to load this message in the networking platform