>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.

A record out of range error can also occur when the index does not match the table.

I would not use a command like RLOCK.

I would use `table buffering` when two applications are using the same data tables. This involves command likes CURSORSETPROP,MULTILOCKS, and TABLEUPDATE.

The command that commits the changes to the physical VFP table is TABLEUPDATE.
There are plenty of examples in the help files, the `TasTrade` application and the Foxpro `solutions` project.



>
>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