>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.