JavaResultSetMBS.absolute(row as Integer) as boolean

Var db as JavaConnectionMBS // your database
Var r as JavaResultSetMBS
Var s as JavaStatementMBS

// check second row
s=db.createStatement
r=s.executeQuery("SELECT * from myTable")

if r<>Nil then
  if r.absolute(2) then
    MsgBox str(R.getInt("test_id"))+" "+r.getString("test_val")
  end if
end if

See the java documentation for details on java.sql.ResultSet.absolute.

Some examples using this method:

• /Java/JavaDatabase/JavaDatabase MySQL Blob and Clob
• /Java/JavaDatabase/JavaDatabase MySQL with JavaInputStreamMBS

JavaResultSetMBS.afterLast

See the java documentation for details on java.sql.ResultSet.afterLast.

JavaResultSetMBS.beforeFirst

See the java documentation for details on java.sql.ResultSet.beforeFirst.

JavaResultSetMBS.cancelRowUpdates

This method may be called after calling an updater method(s) and before calling the method updateRow to roll back the updates made to a row. If no updates have been made or updateRow has already been called, this method has no effect.

See the java documentation for details on java.sql.ResultSet.cancelRowUpdates.

JavaResultSetMBS.clearWarnings

See the java documentation for details on java.sql.ResultSet.clearWarnings.

JavaResultSetMBS.CLOSE_CURSORS_AT_COMMIT as Integer

JavaResultSetMBS.CONCUR_READ_ONLY as Integer

JavaResultSetMBS.CONCUR_UPDATABLE as Integer

JavaResultSetMBS.Constructor   Private

JavaResultSetMBS.deleteRow

See the java documentation for details on java.sql.ResultSet.deleteRow.

JavaResultSetMBS.FetchDirection as Integer

The initial value is determined by the Statement object that produced this ResultSet object. The fetch direction may be changed at any time.

Parameters:
direction - an int specifying the suggested fetch direction; one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
(Read and Write computed property)

JavaResultSetMBS.FetchSize as Integer

If the fetch size specified is zero, the JDBC driver ignores the value and is free to make its own best guess as to what the fetch size should be. The default value is set by the Statement object that created the result set. The fetch size may be changed at any time.

Parameters:
rows - the number of rows to fetch
(Read and Write computed property)

JavaResultSetMBS.FETCH_FORWARD as Integer

This constant is used by the method setFetchDirection as a hint to the driver, which the driver may ignore.

JavaResultSetMBS.FETCH_REVERSE as Integer

This constant is used by the method setFetchDirection as a hint to the driver, which the driver may ignore.

JavaResultSetMBS.FETCH_UNKNOWN as Integer

This constant is used by the method setFetchDirection as a hint to the driver, which the driver may ignore.

JavaResultSetMBS.findColumn(column as string) as Integer

Var r as JavaResultSetMBS // your result set
MsgBox str(r.findColumn("test_id"))+" "+str(r.findColumn("test_val"))

Returns 0 on any error.
See the java documentation for details on java.sql.ResultSet.findColumn.

JavaResultSetMBS.first as boolean

See the java documentation for details on java.sql.ResultSet.first.

JavaResultSetMBS.HOLD_CURSORS_OVER_COMMIT as Integer

JavaResultSetMBS.insertRow

See the java documentation for details on java.sql.ResultSet.insertRow.

JavaResultSetMBS.isAfterLast as boolean

See the java documentation for details on java.sql.ResultSet.isAfterLast.

JavaResultSetMBS.isBeforeFirst as boolean

Returns:
true if the cursor is before the first row; false if the cursor is at any other position or the result set contains no rows

See the java documentation for details on java.sql.ResultSet.isBeforeFirst.

JavaResultSetMBS.isFirst as boolean

See the java documentation for details on java.sql.ResultSet.isFirst.

JavaResultSetMBS.isLast as boolean

See the java documentation for details on java.sql.ResultSet.isLast.

JavaResultSetMBS.last as boolean

See the java documentation for details on java.sql.ResultSet.last.

JavaResultSetMBS.moveToCurrentRow

This method has no effect if the cursor is not on the insert row.

See the java documentation for details on java.sql.ResultSet.moveToCurrentRow.

JavaResultSetMBS.moveToInsertRow

The current cursor position is remembered while the cursor is positioned on the insert row. The insert row is a special row associated with an updatable result set. It is essentially a buffer where a new row may be constructed by calling the updater methods prior to inserting the row into the result set. Only the updater, getter, and insertRow methods may be called when the cursor is on the insert row. All of the columns in a result set must be given a value each time this method is called before calling insertRow. An updater method must be called before a getter method can be called on a column value.

See the java documentation for details on java.sql.ResultSet.moveToInsertRow.

JavaResultSetMBS.NextRecord as boolean

See the java documentation for details on java.sql.ResultSet.next.

JavaResultSetMBS.previousRecord as boolean

See the java documentation for details on java.sql.ResultSet.previous.

JavaResultSetMBS.refreshRow

This method cannot be called when the cursor is on the insert row.
The refreshRow method provides a way for an application to explicitly tell the JDBC driver to refetch a row(s) from the database. An application may want to call refreshRow when caching or prefetching is being done by the JDBC driver to fetch the latest value of a row from the database. The JDBC driver may actually refresh multiple rows at once if the fetch size is greater than one.

All values are refetched subject to the transaction isolation level and cursor sensitivity. If refreshRow is called after calling an updater method, but before calling the method updateRow, then the updates made to the row are lost. Calling the method refreshRow frequently will likely slow performance.

JavaResultSetMBS.relative(row as Integer) as boolean

See the java documentation for details on java.sql.ResultSet.relative.

JavaResultSetMBS.rowDeleted as boolean

A deleted row may leave a visible "hole" in a result set. This method can be used to detect holes in a result set. The value returned depends on whether or not this ResultSet object can detect deletions.
Returns:
true if a row was deleted and deletions are detected; false otherwise

JavaResultSetMBS.rowInserted as boolean

The value returned depends on whether or not this ResultSet object can detect visible inserts.
Returns:
true if a row has had an insertion and insertions are detected; false otherwise

JavaResultSetMBS.rowUpdated as boolean

The value returned depends on whether or not the result set can detect updates.
Returns:
true if both (1) the row has been visibly updated by the owner or another and (2) updates are detected

JavaResultSetMBS.TYPE_FORWARD_ONLY as Integer

JavaResultSetMBS.TYPE_SCROLL_INSENSITIVE as Integer

JavaResultSetMBS.TYPE_SCROLL_SENSITIVE as Integer

JavaResultSetMBS.wasNull as boolean

See the java documentation for details on java.sql.ResultSet.wasNull.