getDeletes method

java.sql.ResultSet UploadedTableData.getDeletes()

A java.sql.ResultSet object that represents delete operations uploaded by a MobiLink client.

The result set contains primary key values for deleted rows.

For more information about direct row handling, see Direct row handling.

For more information about the handle_UploadData connection event, see handle_UploadData connection event.

Assume your remote client contains a table named remoteOrders. The following example uses the DownloadTableData.getDeletes method to obtain a result set of deleted rows. In this case, the delete result set includes a single primary key column.

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 for the remoteOrders table.
    UploadedTableData remoteOrdersTable = ut.getUploadedTableByName("remoteOrders");

    // Get deletes uploaded by the MobiLink client.
    java.sql.ResultSet delete_rs = remoteOrdersTable.getDeletes();

     while (delete_rs.next()) {
         // Get primary key values for deleted rows.
         int deleted_id = delete_rs.getInt(1);

         // ...
    }
    delete_rs.close();
}

getDeletes method

Syntax

Returns

Remarks

Example