>Wait a minute!
>
>I believe Dmitry says there are only 100 rows in this DBF and he says he pulls the whole thing into a cursor.
>
>Solution: REMOVE THE INDEX.
>
>You really don't need an index or indexes on a table that small. FoxPro will suck the whole table into memory in a heartbeat or two.
My first step is enclosing the SQL Select with TRY CATCH (so that the application does not crash).
Then, if I get no errors, I will forget about this issue (and move on to the next one :)).
But if I still get the problem, even after TRY CATCH, I will remove the Index file. You are right, 100 or less records in the EXE should be no problem for VFP. Unless Invalid Seek Offset is caused even when Selecting/Opening a DBF. Nobody but VFPT know what caused the ISO error. We are just guessing that the index file is in the problem.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham