Syntax

public java.sql.ResultSet getInserts( )

Remarks

Returns a java.sql.ResultSet object representing insert operations uploaded by a MobiLink client. Each insert is represented by one row in the result set.

Returns

A java.sql.ResultSet object representing insert operations uploaded by a MobiLink client.

See also

• UploadedTableData interface
• Direct row handling

Example

Assume your remote client contains a table called remoteOrders. The following example uses the DownloadTableData.getInserts method to obtain a result set of inserted rows. The code obtains the order amount for each row in the current upload transaction.

import ianywhere.ml.script.*;
import java.sql.*;

// ...

  // The method used for the handle_UploadData event

  public void HandleUpload( UploadData ut )
    throws SQLException, IOException {
    // Get an UploadedTableData instance representing the remoteOrders table.
    UploadedTableData remoteOrdersTable = ut.getUploadedTableByName("remoteOrders");
 
    // Get inserts uploaded by the MobiLink client.
    java.sql.ResultSet rs = remoteOrdersTable.getInserts();
    while( rs.next() ) { 

    // get the uploaded order_amount
    double order_amount = rs.getDouble("order_amount"); 

    // ...
 
  }
  rs.close();
}