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.
If it's not broken, fix it until it is.
My Blog