Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » MobiLink - Server Administration » Writing Synchronization Scripts in .NET » MobiLink server API for .NET reference » DownloadTableData interface

GetSchemaTable method Next Page

GetUpsertCommand method


Syntax

IDbCommand GetUpsertCommand();

Remarks

Gets a command that allows you to add upsert (insert/update) operations to the direct download data operations. The command that is returned has the same number of parameters as columns in this table. The column values for the insert must be set and the statement executed with ExecuteNonQuery() for the insert/update to be included in the download. ExecuteNonQuery() on the command will return 0 if the insert/update operation was filtered and will return 1 if the insert/update was not filtered.

You cannot add or remove parameters to this command; you can only set their values.

Returns

A Command for inserts/updates for the download.

Example

See DownloadTableData interface.