I am using VFP5.0a.
I have a form with several textbox's tied to Table1 and a grid tied to Table2, with buffermode=2 (Optimistic).
My Add and Edit buttons have a 'Begin Transaction' and the Revert button has 'Rollback'.
The Save button with the following code:
if TableUpdate()
end transaction
else
**other code
endif
The problem is, when Saveing, changes to table1 fields are written, table2 changes are lost as soon as it is closed. I solved the problem by issuung:
=TABLEUPDATE(1, .T., 'Table2')
1. Why is this necessary? Is this because Table2 is in a Grid?
2. If this is necessary, I want to add something like the following to my class that includes my Add, Edit, Save, and Revert buttons similar to:
for ct=1 to NumberOfTablesInDataenvironment
=TABLEUPDATE(1, .T., 'Table'+ct')
endfor
How do I determine the Number of and the Name of each table in the DataEnvironment?
Thanks, Denis
Dennis Schuette