DataWindow Reference
Methods for the DataWindow Control

Description

Clears the update flags in the primary and filter buffers and empties the delete buffer of a DataWindow or DataStore.

Applies to

Syntax

PowerBuilder

integer dwcontrol.ResetUpdate ( ) 

Return value

Returns 1 if it succeeds and -1 if an error occurs.

If dwcontrol is null, in PowerBuilder and JavaScript the method returns null.

Usage

When a row is changed, inserted, or deleted, its update flag is set, making it marked for update. By default the Update method turns these flags off. If you want to coordinate updates of more than one DataWindow or DataStore, however, you can prevent Update from clearing the flags. Then, after you verify that all the updates succeeded, you can call ResetUpdate for each DataWindow to clear the flags. If one of the updates failed, you can keep the update flags, prompt the user to fix the problem, and try the updates again.

You can find out which rows are marked for update with the GetItemStatus method. If a row is in the delete buffer or if it is in the primary or filter buffer and has NewModified! or DataModified! status, its update flag is set. After update flags are cleared, all rows have the status NotModified! or New! and the delete buffer is empty.

Examples

These statements coordinate the update of two DataWindow objects:

int rtncode
CONNECT USING SQLCA;
dw_cust.SetTransObject(SQLCA)
dw_sales.SetTransObject(SQLCA)
 
rtncode = dw_cust.Update(true, false)
IF rtncode = 1 THEN
      rtncode = dw_sales.Update(true, false)
      IF rtncode = 1 THEN
         dw_cust.ResetUpdate() // Both updates are OK
         dw_sales.ResetUpdate()// Clear update flags
         COMMIT USING SQLCA;   // Commit them
      ELSE
         ROLLBACK USING SQLCA; // 2nd update failed
      END IF
END IF

See also

Update