DbSl: SQL errors erroneously translated to ‘duplicate key’

July 1, 2009 at 8:19 am

[] [] [] [] [] [] [] [] [] [] [] [] []

Symptom
Problems with the odbc based DbSl:
(1)
On attempts to write NULL values to NOT NULL columns without default erroneously a duplicate key error is returned.
Correct would be a DB error with SQL error code 515 and message “Cannot insert the value NULL into column ‘…’, table ‘…’; column does not allow nulls.”
(2)
OpenSQL selects with up [...]