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 |