You can't issue a REQUERY inside of a transaction? I am using VFP6 with SQL Server 7 as the backend. I start a VFP transaction, then begin a SQL Server transaction. After that I need to access many different remote views. If all my replacing works, then I end my transaction (both VFP and SQL).

I need to USE a remote view and search for a key. If I don't find it I need to APPEND a new record. The key to that record (found or new) is used to query a child table (based on the parent's key). I then search that table for a particular key. If not found then create a new record. That table then queries another table and the same routine is run on it as above. I need to do this for about 5 tables in depth. If ANYTHING goes wrong then I want to ROLLBACK. If everything goes just fine then I want to COMMIT. The child tables need to constantly requeried to make this work.

The idea of needing to start a transaction at the very top af a series of events then commit everything or rollback everything seems necessary in MANY different environments. How can this concept be accomplished if you can't requery?

Thank you for your insights and ideas.