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