Sets a new value to a column.

Defined in

ODBCResultSet

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.

String. The column name.

A value of a type consistent with the column.

• 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.

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

Example
See Also

AddRow method
FieldExpectedDataType method
FieldID method
FieldName method
FieldSize method
GetRowStatus method
GetValue method
IsValueAltered method
ReadOnly property
UpdateRow method

Glossary