SQLResultSet external type

SQLResultSet represents a result set that is returned from the execution of an SQL query.

EGL package name

eglx.persistence.sql

Example use
Type detail
externalType SQLResultSet extends ScrollableDataSource type NativeType

   private constructor();

   // After a commit, cursors remain open with their positions retained.
   static HOLD_CURSORS_OVER_COMMIT int;

   // After a commit, cursors are closed. 
   static CLOSE_CURSORS_AT_COMMIT int;

   // Cancels row updates made since the previous invocation 
   // of the updateRow function.
   function cancelRowUpdates();

   // Deletes the row in the database.
   function deleteRow();

   // Retrieves the hold status, 
   // whether HOLD_CURSORS_AT_COMMIT or CLOSE_CURSORS_AT_COMMIT.
   function getHoldability() returns(int);

   // retrieves an object from which you can access warning details.
   // each warning is structured as an exception record.
   function getWarnings() returns(SQLWarning?);

   // retrieves the current row again to include changes from other users.
   function refreshRow();

   // indicates whether the current row was deleted since it was retrieved.
   function rowDeleted() returns(boolean);

   // indicates whether the current row was updated since it was retrieved.
   function rowUpdated() returns(boolean);

   // suggests how many rows to retrieve at a time, when necessary.
   function setFetchSize(size int in);

   // updates the row in the database.
   function updateRow();
end
Comments
For a list of functions that position the cursor and that identify the current position, see the documentation for the eglx.persistence.ScrollableDataSource external type.
Compatibility
Table 1. Compatibility
Target Issue
Java No issues.
JavaScript Database access is not supported.