Platforms to show: All Mac Windows Linux Cross-Platform

Back to JavaResultSetMBS class.

Previous items

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.


💬 Ask a question or report a problem
The biggest plugin in space...