SubmitChanges Method

Submits pending changes of the locally cached updatable Recordset to the ODBC data source specified in the Connect property.

Syntax

RDSIE3.DataControl.SubmitChanges

RDSServer.DataFactory.SubmitChanges Connection, Recordset

Part	Description

RDSIE3.DataControl	An object variable that represents an RDSIE3.DataControl object.
RDSServer.DataFactory	An object variable that represents an RDSServer.DataFactory object.
Connection	A String value that represents the connection created with the RDSIE3.DataControl object's Connect property.
Recordset	An object variable that represents a Recordset object.

Applies To

RDSIE3.DataControl, RDSServer.DataFactory

Remarks

The Connect, Server, and SQL properties must be set before you can use the SubmitChanges method with the RDSIE3.DataControl 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 RDSServer.DataFactory object. Custom business objects can't use this method.

Example