>Hi everybody,
>
>I was running a program and getting Invalid Seek Offset in various places. Here is the scenario:
>
>Stage_Trans table has 48 fields (one memo) and 55K records. I was running a process, that replaced records in this file for 6K records. The Stage_Trans was opened in buffered mode 5 with alias Load_Stage_Trans and order cTrans_pk (PK field). The TABLEVALIDATE is 7.
>
>The replace was done using

>if seek(lcTrans_pk,'load_stage_trans','cTrans_pk')
>  replace ..
>endif

>
>The Invalid Seek offset message appeared on different lines of code. Once I removed order, it stopped.

Well, now it re-appeared :( Some other stage tables are opened with indexes, but these tables are not updated. The main tables are updated, but they are not opened with specific order.