Submits pending changes of the locally cached updatable Recordset to the ODBC data source specified in the Connect property.
Syntax
AdvancedDataControl.SubmitChanges
AdvancedDataFactory.SubmitChanges Connection, Recordset
| Part | Description |
| AdvancedDataControl | An object variable that represents an AdvancedDataControl object. |
| AdvancedDataFactory | An object variable that represents an AdvancedDataFactory object. |
| Connection | A String value that represents the connection created with the AdvancedDataControl object's Connect property. |
| Recordset | An object variable that represents a Recordset object. |
Applies To
AdvancedDataControl, AdvancedDataFactory
Remarks
The Connect, Server, and SQL properties must be set before you can use the SubmitChanges method with the AdvancedDataControl object.
If you call the CancelUpdate method after you have called SubmitChanges for the same Recordset object, the CancelUpdate call fails because the changes have already been committed.
Only the changed records are sent for modification, and either all of the changes succeed or all of them fail together.
You can use SubmitChanges only with the default AdvancedDataFactory object. Custom business objects can't use this method.
See Also
Refresh Method, CancelUpdate Method, Address Book Command Buttons, Using AdvancedDataControl to Pass Updated Recordsets to the Middle Tier
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.