ADO » DataControl » SubmitChanges
- Syntax:
- datacontrolobject.SubmitChanges
Sends all of the pending changes in the locally cached Recordset object down to the underlying data source.
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.
Examples
Code:
Sub SubmitChange_OnClick
objDataControl.SubmitChanges
objDataControl.Refresh
End Sub
Sub CancelUpdate_OnClick
objDataControl.CancelUpdate
objDataControl.Refresh
End Sub
See Also:
