SetValue (ODBCResultSet - LotusScript)
Sets a new value to a column.
Defined in
Syntax
status = odbcResultSet . SetValue( column_id% , value )
or
status = odbcResultSet . SetValue( column_Name$ , value )
Parameters
column_id%
Integer. The column ID. Use any numeric data type, except Currency.
column_Name$
String. The column name.
value
A value of a type consistent with the column.
Return value
- True indicates that the current value in specified column is updated by value.
- False indicates that the value cannot be changed, as when the result set is read-only.
Usage
The data is automatically converted to the required native data type.
The changes take effect when an UpdateRow operation occurs.
Specify the value argument as Null to set a null value of the correct type.
Errors
Read only. Data cannot be updated or deleted (DBstsRDON)
The row has previously been deleted (DBstsROWD)
Field ID is out of range (DBstsINVC)
Cannot convert data from native to expected or requested datatype (DBstsCNVR)
The result contains no data (DBstsNODA)
Events
BeforeSetValue
AfterSetValue