>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.
try to
REINDEX
post some "lines of code" where the Invalid happen.
If the error persists, test to perform the code with "SET EXCLUSIVE ON"