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.getDate(column as integer) as JavaObjectMBS

See also:

• getDate(column as string) as JavaObjectMBS

JavaResultSetMBS.getDate(column as string) as JavaObjectMBS

See also:

• getDate(column as integer) as JavaObjectMBS

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

Var 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

Var 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.getTime(column as integer) as JavaObjectMBS

See also:

• getTime(column as string) as JavaObjectMBS

JavaResultSetMBS.getTime(column as string) as JavaObjectMBS

See also:

• getTime(column as integer) as JavaObjectMBS

JavaResultSetMBS.getTimestamp(column as integer) as JavaObjectMBS

See also:

• getTimestamp(column as string) as JavaObjectMBS

JavaResultSetMBS.getTimestamp(column as string) as JavaObjectMBS

See also:

• getTimestamp(column as integer) as JavaObjectMBS

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

JavaResultSetMBS.getUnicodeStream(column as Integer) as JavaInputStreamMBS

Retrieves the value of the designated column in the current row of this ResultSet object as as a stream of two-byte 3 characters. The first byte is the high byte; the second byte is the low byte. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHARvalues. The JDBC driver will do any necessary conversion from the database format into Unicode.
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 two-byte Unicode 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
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

See also:

• getUnicodeStream(column as string) as JavaInputStreamMBS

JavaResultSetMBS.getUnicodeStream(column as string) as JavaInputStreamMBS

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of two-byte Unicode characters. The first byte is the high byte; the second byte is the low byte. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC technology-enabled driver will do any necessary conversion from the database format into Unicode.
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 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 two-byte Unicode 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
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

See also:

• getUnicodeStream(column as Integer) as JavaInputStreamMBS