"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 | Description |
|---|---|
|
SQLCode |
1000122L |
|
Constant |
EMSG_CANNOT_CONVERT_FOR_UPDATE |
|
SQLState |
00B22 |
|
ODBC 2 State |
OK |
|
ODBC 3 State |
OK |
|
Sybase Error Code |
20782 |
|
Severity Code |
|
|
Parameter 1 |
The table being updated. |
|
Parameter 2 |
The column being updated. |
|
Parameter 3 |
The n'th update to the table. |
The database option CONVERSION_ERROR has been set to 'OFF' for this UPDATE. During UPDATE, the data to update one of the columns cannot be converted to the datatype of the column. The update number represents the number of updates made to the table which is not necessarily the row number of the table being updated. The column will be updated with NULL if the column definition allows NULLs.