The data to be inserted into table '%2', column '%1' from row '%3' of the select results cannot be converted to the datatype of the destination column. NULL will be inserted if the column allows NULLs.
Item |
Value |
|---|---|
SQLCode |
1000119L |
Constant |
EMSG_CANNOT_CONVERT_FOR_INSERT_SELECT |
SQLState |
00B19 |
ODBC State |
OK |
Parameter 1 |
the column being inserted into |
Parameter 2 |
the table being inserted into |
Parameter 3 |
the row number in the SELECT results that contains the data that cannot be converted |
The database option CONVERSION_ERROR is set to 'OFF' for this INSERT...SELECT. During INSERT...SELECT, the data to be inserted to one of the columns cannot be converted to the data type of that column. If the column allows NULL, then NULL is inserted instead. 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.
