General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
How about leaving them #'s...
Index on field1+(field2*10000) tag whatever
make the multiplier bigger than your largest value you'd have in your field1 that will have the effect of "offsetting" the two #'s.
Index on f1+f2 tag whatever
if f1 is 1 and f2 is 4 "seek(5)" would work.. that's not a very good key.
but yes; str() would work too.
>What is the best way to create a compound index with integer fields?
>
>field1 is integer.
>field2 is integer.
>
>When I create an index like INDEX ON field1 + field2 TAG tagname1, foxpro seems to get "confused".
>
>Must I use the STR() function around field1 and field2?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only