IDataReader GetInserts();Gets a DataReader with the inserts for this uploaded table data. Each Insert is represented by one row returned by the reader.
A DataReader with inserts for this table data.
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();
} |
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |