SDAC Default or NULL
Posted: Sun 27 Apr 2008 22:13
Hi
I use Cbuilder 2006 and latest SDAC 4.35.1.16 and MSSQL 2005
I have some money field with default value (0). A do some calculation so I can't have values of NULL.
But if a delete all values and send 'NULL' from the program MSSQL acept this and update the table with NULL value even default is (0).
I don't now if this is a MSSQL error or SDAC error.
For me it makes no sens to be able to update a column with NULL when deafault value is (0).
I use Cbuilder 2006 and latest SDAC 4.35.1.16 and MSSQL 2005
I have some money field with default value (0). A do some calculation so I can't have values of NULL.
But if a delete all values and send 'NULL' from the program MSSQL acept this and update the table with NULL value even default is (0).
I don't now if this is a MSSQL error or SDAC error.
For me it makes no sens to be able to update a column with NULL when deafault value is (0).