Platforms to show: All Mac Windows Linux Cross-Platform

Back to JavaResultSetMBS class.

Previous items

JavaResultSetMBS.getUnicodeStream(column as Integer) as JavaInputStreamMBS

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 13.1 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Deprecated. use getCharacterStream in place of getUnicodeStream

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:

JavaResultSetMBS.getUnicodeStream(column as string) as JavaInputStreamMBS

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 13.1 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Deprecated. use getCharacterStream instead

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:

JavaResultSetMBS.HOLD_CURSORS_OVER_COMMIT as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
The constant indicating that ResultSet objects should not be closed when the method Connection.commit is called.

JavaResultSetMBS.insertRow

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Inserts the contents of the insert row into this ResultSet objaect and into the database.

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

JavaResultSetMBS.isAfterLast as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Indicates whether the cursor is after the last row in this ResultSet object.

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

JavaResultSetMBS.isBeforeFirst as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Retrieves whether the cursor is before the first row in this ResultSet object.

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

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Indicates whether the cursor is on the first row of this ResultSet object.

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

JavaResultSetMBS.isLast as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Indicates whether the cursor is on the last row of this ResultSet object.

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

JavaResultSetMBS.last as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Moves the cursor to the last row in this ResultSet object.

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

JavaResultSetMBS.moveToCurrentRow

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Moves the cursor to the remembered cursor position, usually the current row.

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

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Moves the cursor to the insert row.

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

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Moves the cursor down one row from its current position.

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

JavaResultSetMBS.previousRecord as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Moves the cursor to the previous row in this ResultSet object.

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

JavaResultSetMBS.refreshRow

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Refreshes the current row with its most recent value in the database.

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

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Moves the cursor a relative number of rows, either positive or negative.

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

JavaResultSetMBS.rowDeleted as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Retrieves whether a row has been deleted.

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

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Retrieves whether the current row has had an insertion.

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

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Retrieves whether the current row has been updated.

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

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
The constant indicating the type for a ResultSet object whose cursor may move only forward.

JavaResultSetMBS.TYPE_SCROLL_INSENSITIVE as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
The constant indicating the type for a ResultSet object that is scrollable but generally not sensitive to changes made by others.

JavaResultSetMBS.TYPE_SCROLL_SENSITIVE as Integer

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
The constant indicating the type for a ResultSet object that is scrollable and generally sensitive to changes made by others.

JavaResultSetMBS.updateBlob(column as Integer, value as JavaBlobMBS)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a java.sql.Blob value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

column: the first column is 1, the second is 2, ...
value: the new column value

See also:

Some examples using this method:

JavaResultSetMBS.updateBlob(column as string, value as JavaBlobMBS)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a java.sql.Blob value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

column: the name of the column
value: the new column value

See also:

JavaResultSetMBS.updateBoolean(column as Integer, value as boolean)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a boolean value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value

See also:

JavaResultSetMBS.updateBoolean(column as string, value as boolean)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a boolean value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName - the name of the column
x - the new column value

See also:

JavaResultSetMBS.updateByte(column as Integer, value as Integer)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a byte value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value

See also:

JavaResultSetMBS.updateByte(column as string, value as Integer)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a byte value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName - the name of the column
x - the new column value

See also:

JavaResultSetMBS.updateBytes(column as Integer, Value as String)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a byte array value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
column: column index starting at 1.
Value: The new byte array as a string.

See also:

JavaResultSetMBS.updateBytes(column as string, Value as String)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 11.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a byte array value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
column: The column name.
Value: The new byte array as a string.

See also:

JavaResultSetMBS.updateClob(column as Integer, value as JavaClobMBS)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a java.sql.Clob value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

column: the first column is 1, the second is 2, ...
value: the new column value

See also:

Some examples using this method:

JavaResultSetMBS.updateClob(column as string, value as JavaClobMBS)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a java.sql.Clob value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

column: the name of the column
value: the new column value

See also:

JavaResultSetMBS.updateDouble(column as Integer, value as Double)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a double value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value

See also:

JavaResultSetMBS.updateDouble(column as string, value as Double)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a double value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName - the name of the column
x - the new column value

See also:

JavaResultSetMBS.updateFloat(column as Integer, value as single)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a float value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value

See also:

JavaResultSetMBS.updateFloat(column as string, value as single)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a float value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName - the name of the column
x - the new column value

See also:

JavaResultSetMBS.updateInt(column as Integer, value as Integer)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with an int value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value

See also:

JavaResultSetMBS.updateInt(column as string, value as Integer)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with an int value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName - the name of the column
x - the new column value

See also:

JavaResultSetMBS.updateLong(column as Integer, value as int64)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a long value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value

See also:

JavaResultSetMBS.updateLong(column as string, value as int64)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a long value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName - the name of the column
x - the new column value

See also:

JavaResultSetMBS.updateNull(column as Integer)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Gives a nullable column a null value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...

See also:

JavaResultSetMBS.updateNull(column as string)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a null value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName - the name of the column

See also:

JavaResultSetMBS.updateRow

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the underlying database with the new contents of the current row of this ResultSet object.
Example
dim r as JavaResultSetMBS
dim db as JavaConnectionMBS // your database
dim s as JavaStatementMBS

s=db.createStatement
r=s.executeQuery("SELECT test_id from myTable")

if r<>Nil then
while r.NextRecord
r.updateInt("test_id",10+r.getInt("test_id"))
r.updateRow
wend
end if

This method cannot be called when the cursor is on the insert row.

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

Some examples using this method:

JavaResultSetMBS.updateShort(column as Integer, value as Integer)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a short value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value

See also:

JavaResultSetMBS.updateShort(column as string, value as Integer)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.5 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a short value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName - the name of the column
x - the new column value

See also:

JavaResultSetMBS.updateString(column as Integer, value as string)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a String value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex - the first column is 1, the second is 2, ...
x - the new column value

See also:

JavaResultSetMBS.updateString(column as string, value as string)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Updates the designated column with a String value.

The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
Parameters:
columnName - the name of the column
x - the new column value

See also:

JavaResultSetMBS.wasNull as boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 8.3 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
Reports whether the last column read had a value of SQL NULL.

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

Previous items

The items on this page are in the following plugins: MBS Java Plugin.


The biggest plugin in space...