The data to update table '%2', column '%1' cannot be converted to the datatype of the destination column for update number %3 to the table. NULL will be inserted if the column allows NULLs.
Item |
Value |
|---|---|
SQLCode |
1000122L |
Constant |
EMSG_CANNOT_CONVERT_FOR_UPDATE |
SQLState |
00B22 |
ODBC State |
OK |
Parameter 1 |
the column being updated |
Parameter 2 |
the table being updated |
Parameter 3 |
the nth update to the table |
The database option CONVERSION_ERROR is set to 'OFF' for this UPDATE. During UPDATE, the data to update one of the columns cannot be converted to the data type of the column. The update number represents the number of updates made to the table and is not necessarily the row number of the table being updated. The column is updated with NULL, if the column definition allows NULLs. If the column does not allow NULL, then the error “Tried to insert a null value into a non-null field field_name on row row_number.” is returned.
