Tnx
>>Hi
>>
>>Help Please,
>>
>>I have the following index:
>>
>>
ALLTRIM(TTOC(sdatetime)+ALLTRIM(phone)+ALLTRIM(STR(id1))+ALLTRIM(STR(id2)))
>>
>>When I try to populate the table (alias), I get error message:"Error building key for index"
>
>Don't use ALLTRIM for INDEXES and use TTOC(sdatetime,1) instead.
>
>So, your index will be
>
>TTOC(sdateTime,1) + phone + bintoc(id1) + bintoc(id2)
>
>You would need to padr the values to their length when you construct your seek expression.
Thank you
Chaim