Update column values
- Last Updated: February 11, 2026
- 2 minute read
- OpenEdge
- Version 13.0
- Documentation
The following methods modify a column in an SDOResultSet according to the specified data type. All column access methods in SDOResultSet use the flat model (see Learn about Open Clients). The column is specified by name (columnName) or number (columnIndex) and is set to the specified value (value), as follows:
-
void updateBigDecimal(intcolumnIndex, BigDecimalvalue) -
void updateBigDecimal(StringcolumnName, BigDecimalvalue) -
void updateBlob(intcolumnIndex, java.sql.Blobvalue) -
void updateBlob(StringcolumnName, java.sql.Blobvalue) -
void updateBoolean(intcolumnIndex, booleanvalue) -
void updateBoolean(StringcolumnName, booleanvalue) -
void updateBytes(intcolumnIndex, byte x[]) -
void updateBytes(StringcolumnName, byte x[]) -
void updateClob(intcolumnIndex, java.sql.Clobvalue) -
void updateClob(StringcolumnName, java.sql.Clobvalue) -
void updateDate(intcolumnIndex, java.sql.Datevalue) -
void updateDate(StringcolumnName, java.sql.Datevalue) -
void updateDouble(intcolumnIndex, doublevalue) -
void updateDouble(StringcolumnName, doublevalue) -
void updateInt(intcolumnIndex, intvalue) -
void updateInt(StringcolumnName, intvalue) -
void updateLong(intcolumnIndex, longvalue) -
void updateLong(StringcolumnName, longvalue) -
void updateNull(intcolumnIndex) -
void updateNull(StringcolumnName) -
void updateObject(intcolumnIndex, Objectvalue) -
void updateObject(StringcolumnName, Objectvalue) -
void updateString(intcolumnIndex, Stringvalue) -
void updateString(StringcolumnName, Stringvalue) -
void updateTimestamp(intcolumnIndex, java.sql.TimeStampvalue) -
void updateTimestamp(StringcolumnName, java.sql.TimeStampvalue)
Some java.util.Date and java.sql.Date methods
are being deprecated by JavaSoft in favor of using the more robust java.util.GregorianCalendar.
These are the methods that update column values with instances of
this class:
-
void updateGregorianCalendar(StringcolumnName, GregorianCalendardate) [Extension] -
void updateGregorianCalendar(intcolumnIndex, GregorianCalendardate) [Extension]
For more information on the mapping between ABL and Java data
types for SQL ResultSet applications, see Pass Temp-tables as SQL ResultSet Parameters.