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:

• updateBlob(column as string, value as JavaBlobMBS)

Some examples using this method:

• /Java/JavaDatabase/JavaDatabase MySQL Blob and Clob

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:

• updateBlob(column as Integer, value as JavaBlobMBS)

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:

• updateBoolean(column as string, value as boolean)

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:

• updateBoolean(column as Integer, value as boolean)

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:

• updateByte(column as string, value as Integer)

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:

• updateByte(column as Integer, value as Integer)

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:

• updateBytes(column as string, Value as String)

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:

• updateBytes(column as Integer, Value as String)

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:

• updateClob(column as string, value as JavaClobMBS)

Some examples using this method:

• /Java/JavaDatabase/JavaDatabase MySQL Blob and Clob

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:

• updateClob(column as Integer, value as JavaClobMBS)

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:

• updateDouble(column as string, value as Double)

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:

• updateDouble(column as Integer, value as Double)

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:

• updateFloat(column as string, value as single)

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:

• updateFloat(column as Integer, value as single)

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:

• updateInt(column as string, value as Integer)

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:

• updateInt(column as Integer, value as Integer)

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:

• updateLong(column as string, value as int64)

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:

• updateLong(column as Integer, value as int64)

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:

• updateNull(column as string)

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:

• updateNull(column as Integer)