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

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)

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)

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)

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)

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)

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)

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)

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)

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)

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.updateDate(column as integer, value as JavaObjectMBS)

You need to create a java.sql.Date object yourself to use this.

See also:

• updateDate(column as string, value as JavaObjectMBS)

JavaResultSetMBS.updateDate(column as string, value as JavaObjectMBS)

You need to create a java.sql.Date object yourself to use this.

See also:

• updateDate(column as integer, value as JavaObjectMBS)

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

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

JavaResultSetMBS.updateRow

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

• /Java/JavaDatabase/JavaDatabase MySQL Blob and Clob

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

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:

• updateShort(column as string, value as Integer)

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

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:

• updateShort(column as Integer, value as Integer)

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

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:

• updateString(column as string, value as string)

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

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:

• updateString(column as Integer, value as string)

JavaResultSetMBS.updateTime(column as integer, value as JavaObjectMBS)

You need to create a java.sql.Time object yourself to use this.

See also:

• updateTime(column as string, value as JavaObjectMBS)

JavaResultSetMBS.updateTime(column as string, value as JavaObjectMBS)

You need to create a java.sql.Time object yourself to use this.

See also:

• updateTime(column as integer, value as JavaObjectMBS)

JavaResultSetMBS.updateTimestamp(column as integer, value as JavaObjectMBS)

You need to create a java.sql.Timestamp object yourself to use this.

See also:

• updateTimestamp(column as string, value as JavaObjectMBS)

JavaResultSetMBS.updateTimestamp(column as string, value as JavaObjectMBS)

You need to create a java.sql.Timestamp object yourself to use this.

See also:

• updateTimestamp(column as integer, value as JavaObjectMBS)