Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid Seek Offset - reproducible
Message
From
20/07/2006 02:29:04
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01137918
Message ID:
01137934
Views:
19
>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"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform