Hi,
>>
I have a form with two tables, both are using "5-Optimistic Table Buffering".
TableA has one-to-many relationship with TableB. When a record is changed in TableA, there are more than one Records affected in TableB.
When I want to issue Table Update, what should I do?
Currently I am using
TableUpdate(1,.f.,"tableA") and
TableUpdate(1,.f.,"tableB")
Is it correct?
>>
There is a danger that the update to tableA will succeed but the update to tableB will fail. Use a transaction to wrap the two updates:
BEGIN TRANSACTION
IF TABLEUPDATE(1,.f.,"tableA") .AND. TABLEUPDATE(1,.f.,"tableB")
END TRANSACTION
ELSE
ROLLBACK
ENDIF
>>
I have another problem where when after I issue TableRevert(.t.,"TableA") while on record number X, if I go to Record number Y and issue TableUpdate(1,.f.,"TableA"), the record number changes to X automatically.
>>
From TableUpdate Help:
If table buffering is used and multiple records are updated, TABLEUPDATE( ) moves the record pointer to the last record updated.
HTH,
Viv