Hi,
I have similar problems here but.. may be bit different.
I have an Application - AppA running on networked/local machine that access the same database. At the end of the day, user will shutdown all AppA and then run another replication application (EXE) written using VFP to send updated transaction to web.

Sometime, my replication application failed to retrieve the updated data. It seem like the updated records doesn't included in cursor "SELECTed" using SQL statement.

Recently, I just add RLOCK() and UNLOCK to "force" VFP to get the "refreshed" table. Does it really work?

I just wondering that, why my replication EXE could fail to get the updated data even it is run after all my AppA have been shutdown. Pls advise!

Thank you