Hi,

I had 02 separate VFP5a written application.
The first program just open a dbf with around 100 record
to update to data.dbf , by doing searching (using compound index) , append, rlock and update record
before unlock the record

My other program just search through the data.dbf for
some value and need to go to that recno later. However,
due to my first program updating new record, my second
program might give 'Record out of range' and might
halt too.

How should I solve the 'record out of range' issue
in my second application. Should I do a 'flush' command
in my first application.

However, I can't understand why my second program just
halt due to my updating of the data.dbf file, any good
suggestion to solve the issue. My second program will
not halt if I didn't run my first program concurrently.

Any advise or suggestion is very much appreciated.
Thank you