>Hi,
>
>My table has two Int fields. I want to create an index tag so that I can use SEEK() with two Int values.
>Example:
>table has fields FLD1 Int, FLD2 Int.
>Two variables iVar1 and iVar2
>
>

>if seek( ..... )
>
>endif
>

>
>what would the the expression?
>

>index on ....    FLD1 ..... FLD2 ... TAG tagName
>

You could convert to CHAR and concatenate e.g.

INDEX ON STR( Fld1 ) + STR( Fld2 ) ...

but if you do that you'd need to SEEK on STR( Fld1 ) + STR( Fld2 ).

I'd be inclined to just index the columns individually, to separate tags, then use LOCATE:

LOCATE FOR Fld1 = iVar1 AND Fld2 = iVar2

The latter approach should be fully Rushmore optimizable. I don't know whether the first one would be faster or slower.