ResetUpdate

Description

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

Applies to

Syntax

integer dwcontrol.ResetUpdate ( ) 

short dwcontrol.ResetUpdate ( )

number dwcontrol.ResetUpdate ( ) 

Returns

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

Example 1

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