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

GetDeletes method Next Page

GetInserts method


Syntax

IDataReader GetInserts();

Remarks

Gets a DataReader with the inserts for this uploaded table data. Each Insert is represented by one row returned by the reader.

Returns

A DataReader with inserts for this table data.

Example
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.GetInserts();

   while( data_reader.Read() ) {
     StringBuilder row_str = new StringBuilder( "( " );
     row_str.Append( data_reader.GetString( 0 ) ); // pcol1
     row_str.Append( ", " );
     if( data_reader.IsDBNull( 1 ) ) {
       row_str.Append( "<NULL>" );
       } else {
       row_str.Append( data_reader.GetString( 1 ) ); // col2
       }
     row_str.Append( ", " );
     row_str.Append( data_reader.GetString( 2 ) ); // pcol3
     row_str.Append( " )" );
     writer.WriteLine( row_str );
}
data_reader.Close();
}