I'm indexing a remote view (AS/400 via ODBC) in order to create a relation to a local table. The index is based on two fields. The first field is of type Character that contains variable length data (Alpha Numeric). The second field is Numeric containing fixed length data.

My index looks like this: INDEX ON LEFT(odord_,6)+ RIGHT(STR(odadte,6),6) to Scratch

My problem is that occasionally I will get an Invalid Seek Offset error. Whats wrong?

TIA

Don Burton