>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
Don,
Invlaid Seek Offset may or may not be related to an index. I believe the Seek Offset being referred to here is a memory seek that Fox is trying to do. You can try and recreate the index and see if the error disappears, otherwise you may have a memory conflict on the machine. Memory conflicts are most often involved with driver software usually the video and sometimes the printer drivers. You can try running the app using the generic video and printer drivers that come with windows and see if the error is eliminated, if it si then the drivers are causing a conflict and you can seek updated ones from the vendor.