>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?
Let me clarify my previous post. In this case you would use:
INDEX ON BINTOC(field1) + BINTOC(field2) TAG tagname
George
Ubi caritas et amor, deus ibi est