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 » UploadedTableData interface

UploadedTableData interface Next Page

GetDeletes method


IDataReader GetDeletes();


Gets a DataReader with the deletes for this uploaded table data. Each delete is represented by the primary key values needed to uniquely represent a row in this instances table.

Note: The index and order of the columns will match the array for property DataTable.PrimaryKey for the schema of this table.


A DataReader with primary key columns for deleted rows.


Assume your remote client contains a table called sparse_pk. The following example uses the DownloadTableData.GetDeletes method to obtain a data reader of deleted rows. In this case, the delete datareader includes two primary key columns. Note the index of each primary key column.

CREATE TABLE sparse_pk (
     pcol1  INT NOT NULL,
     col2 VARCHAR(200),
     pcol3 INT NOT NULL,
     PRIMARY KEY ( pcol1, pcol3 )

  using iAnywhere.MobiLink.Script;
  using System;
  using System.IO;
  using System.Data;
  using System.Text;
  // The method used for the handle_UploadData event.

  public void HandleUpload( UploadData ut ) {
   // Get an UploadedTableData for the sparse_pk table.
   UploadedTableData sparse_pk_table = ut.GetUploadedTableByName("sparse_pk");
   // Get deletes uploaded by the MobiLink client.
   IDataReader data_reader = sparse_pk_table.GetDeletes();

   while( data_reader.Read() ) {
     StringBuilder row_str = new StringBuilder( "( " );
     row_str.Append( data_reader.GetString( 0 ) ); // pcol1
     row_str.Append( ", " );
     row_str.Append( data_reader.GetString( 1 ) ); // pcol3
     row_str.Append( " )" );
     writer.WriteLine( row_str );