JavaResultSetMBS.absolute(row as Integer) as boolean

dim db as JavaConnectionMBS // your database
dim r as JavaResultSetMBS
dim 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

dim 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.getAsciiStream(column as Integer) as JavaInputStreamMBS

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method InputStream.available is called whether there is data available or not.

Parameters:
column: the first column is 1, the second is 2, ...

Returns a Java input stream that delivers the database column value as a stream of one-byte ASCII characters; if the value is SQL NULL, the value returned is null

Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.

See also:

• getAsciiStream(column as string) as JavaInputStreamMBS

JavaResultSetMBS.getAsciiStream(column as string) as JavaInputStreamMBS

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

Parameters:
column: the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns a Java input stream that delivers the database column value as a stream of one-byte ASCII characters. If the value is SQL NULL, the value returned is null.

Throws:
SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

See also:

• getAsciiStream(column as Integer) as JavaInputStreamMBS

JavaResultSetMBS.getBinaryStream(column as Integer) as JavaInputStreamMBS

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method InputStream.available is called whether there is data available or not.

Parameters:
column: the first column is 1, the second is 2, ...

Returns a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the value is SQL NULL, the value returned is null

Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

See also:

• getBinaryStream(column as string) as JavaInputStreamMBS

Some examples using this method:

• /Java/JavaDatabase/JavaDatabase MySQL with JavaInputStreamMBS
• /Java/JavaDatabase/JavaDatabase SQLite blob

JavaResultSetMBS.getBinaryStream(column as string) as JavaInputStreamMBS

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

Parameters:
column: the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the value is SQL NULL, the result is null.

Throws SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

See also:

• getBinaryStream(column as Integer) as JavaInputStreamMBS

JavaResultSetMBS.getBlob(column as Integer) as JavaBlobMBS

Column: the first column is 1, the second is 2, ...

Returns a Blob object representing the SQL BLOB value in the specified column

See also:

• getBlob(column as string) as JavaBlobMBS

JavaResultSetMBS.getBlob(column as string) as JavaBlobMBS

column: the name of the column from which to retrieve the value
Returns a Blob object representing the SQL BLOB value in the specified column

See also:

• getBlob(column as Integer) as JavaBlobMBS

JavaResultSetMBS.getBoolean(column as Integer) as boolean

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

See also:

• getBoolean(column as string) as boolean

JavaResultSetMBS.getBoolean(column as string) as boolean

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

See also:

• getBoolean(column as Integer) as boolean

JavaResultSetMBS.getByte(column as Integer) as Integer

Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is 0

See also:

• getByte(column as string) as Integer

JavaResultSetMBS.getByte(column as string) as Integer

Parameters:
columnName - the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is 0

See also:

• getByte(column as Integer) as Integer

JavaResultSetMBS.getBytes(column as Integer) as string

column: the first column is 1, the second is 2, ...
the plugin gives you the bytes as a string with no encoding.

See also:

• getBytes(column as string) as string

JavaResultSetMBS.getBytes(column as string) as string

the plugin gives you the bytes as a string with no encoding.

See also:

• getBytes(column as Integer) as string

JavaResultSetMBS.getClob(column as Integer) as JavaClobMBS

Column: the first column is 1, the second is 2, ...
Returns a Clob object representing the SQL CLOB value in the specified column

See also:

• getClob(column as string) as JavaClobMBS

JavaResultSetMBS.getClob(column as string) as JavaClobMBS

column: the name of the column from which to retrieve the value
Returns a Clob object representing the SQL CLOB value in the specified column

See also:

• getClob(column as Integer) as JavaClobMBS

JavaResultSetMBS.getConcurrency as Integer

The concurrency used is determined by the Statement object that created the result set.
Returns:
the concurrency type, either ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

JavaResultSetMBS.getCursorName as string

In SQL, a result table is retrieved through a cursor that is named. The current row of a result set can be updated or deleted using a positioned update/delete statement that references the cursor name. To insure that the cursor has the proper isolation level to support update, the cursor's SELECT statement should be of the form SELECT FOR UPDATE. If FOR UPDATE is omitted, the positioned updates may fail.

The JDBC API supports this SQL feature by providing the name of the SQL cursor used by a ResultSet object. The current row of a ResultSet object is also the current row of this SQL cursor.

Note: If positioned update is not supported, a SQLException is thrown.

Returns:
the SQL name for this ResultSet object's cursor

JavaResultSetMBS.getDouble(column as Integer) as Double

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

See also:

• getDouble(column as string) as Double

JavaResultSetMBS.getDouble(column as string) as Double

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

See also:

• getDouble(column as Integer) as Double

JavaResultSetMBS.getFloat(column as Integer) as single

Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is 0

See also:

• getFloat(column as string) as single

JavaResultSetMBS.getFloat(column as string) as single

Parameters:
columnName - the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is 0

See also:

• getFloat(column as Integer) as single

JavaResultSetMBS.getInt(column as Integer) as Integer

Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is 0

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

See also:

• getInt(column as string) as Integer

JavaResultSetMBS.getInt(column as string) as Integer

dim r as JavaResultSetMBS // your result set
MsgBox str(R.getInt("test_id"))+" "+r.getString("test_val")

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

See also:

• getInt(column as Integer) as Integer

JavaResultSetMBS.getLong(column as Integer) as int64

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

See also:

• getLong(column as string) as int64

JavaResultSetMBS.getLong(column as string) as int64

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

See also:

• getLong(column as Integer) as int64

JavaResultSetMBS.getMetaData as JavaResultSetMetaDataMBS

Returns:
the description of this ResultSet object's columns

JavaResultSetMBS.getRow as Integer

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

JavaResultSetMBS.getShort(column as Integer) as Integer

Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is 0.

See also:

• getShort(column as string) as Integer

JavaResultSetMBS.getShort(column as string) as Integer

Parameters:
columnName - the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is 0

See also:

• getShort(column as Integer) as Integer

JavaResultSetMBS.getString(column as Integer) as string

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

See also:

• getString(column as string) as string

JavaResultSetMBS.getString(column as string) as string

dim r as JavaResultSetMBS // your result set
MsgBox str(R.getInt("test_id"))+" "+r.getString("test_val")

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

See also:

• getString(column as Integer) as string

JavaResultSetMBS.getType as Integer

The type is determined by the Statement object that created the result set.
Returns:
ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE