METHOD:  DataControl::SubmitChanges
datacontrolobject.SubmitChanges

The SubmitChanges method is called to submit any pending changes to the data source of the Recordset.

The Recordset must be updateable. Also, the Connect, Server, and SQL properties must first be set. If the URL property is set, the pending changes will be sent to the specified location. If the pending changes have been filtered, only those pending changes that survived being filtered will be sent to the data source for updating.

Note that only the changes are submitted, not the entire Recordset. Every one of the changes must be successfully completed or the entire update attempt fails and none of the changes will be committed to the data source.

You can use buttons on a Web page to navigate and manipulate a displayed recordset. For example, when the appropriate button is clicked, you can call a subroutine containing either this method or the CancelUpdate method:

Code (VBScript):
Sub SubmitChange_OnClick
   objDataControl.SubmitChanges
   objDataControl.Refresh
End Sub

Sub CancelUpdate_OnClick
   objDataControl.CancelUpdate
   objDataControl.Refresh
End Sub
Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information