I'm using VFP 8.0 with .dbf tables. I got many complain from my clients that sometimes the tables were not updated.

In the updating, after all the replaces and inserts, I have:

dAll=.n.
begin transaction
select stock
if tableupdate(.t.)
   select stockdetail
   if tableupdate(.t.)
      select cust
      if tableupdate(.t.)
         dAll=.y.
      endif
   endif
endif

IF dAll
   END TRANSACTION 
ELSE
   ROLLBACK
   WAIT WINDOW 'Rollback, call your dealer'
ENDIF

all the tables are Optimistic table buffering (5), I have around 15 tables to update.

at the beginning, I'm very confident the code will work, but after I received so many complains from difference clients, I have no more confident. none of them got the Rollback message but some of tables were not updated.

am I missing something?

please advise.

regards,

Jerry