The data to be inserted into table '%2', column '%1' cannot be converted to the datatype of the column. NULL will be inserted if the column allows NULLs.
Item |
Value |
|---|---|
SQLCode |
1000117L |
Constant |
EMSG_CANNOT_CONVERT_FOR_INSERT |
SQLState |
00B17 |
ODBC State |
OK |
Parameter 1 |
the column being inserted into |
Parameter 2 |
the table being inserted into |
The database option CONVERSION_ERROR is set to 'OFF' for this INSERT. The data to be inserted to the named column 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.
