Push Method (RDA)
Uploads changes from a pulled tracked table in Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) back to the originating table in Microsoft SQL Server. These changes are either individually applied to the server or batched together in a single transaction.
To use the Push method, the application must have created the local SQL Server Compact Edition table by calling the Pull method with theRDA_TRACKOPTIONparameter set to either TRACKINGON or TRACKINGONWITHINDEXES.
Before calling the Push method, the following properties must be set:
- The InternetUrl property must contain the URL of the SQL Server Compact Edition Server Agent.
- The LocalConnectionString property must contain the OLE DB connection string for the SQL Server Compact Edition database on the device.
- The InternetLogin and InternetPassword properties must be specified if the SQL Server Compact Edition Server Agent is configured to use Basic or Integrated Authentication.
Syntax
object.Push (LocalTableName, OLEDBConnectionString, RDA_BATCHOPTION)
Parameters
- LocalTableName
The name of the pulled tracked SQL Server Compact Edition table that contains updated records to be sent back to the SQL Server table.
- OLEDBConnectionString
The OLE DB connection string for the SQL Server database. For more information, see LocalConnectionString Property (SQL Server Compact Edition).
- RDA_BATCHOPTION
The RDA_BATCHOPTION enumeration. Specifies whether the rows being sent back to the SQL Server table should be batched together in a single transaction or applied individually. For more information, see RDA_BATCHOPTION.
Applies To
SQL Server Compact Edition RDA object
Remarks
If you specify the ErrorTableName parameter when calling the Pull method, any errors that are detected during the push are logged in the error table. For more information about how the error table works, see RDA Conflict Detection and Reporting.
See Also
Reference
RDA Object Methods
Pull Method (RDA)