Null inserted by form even when field has default
I have a problem with default values in my SQL Server tables.
I have a table with default values set to some fields, but I find that when I bind my controls to those fields, they do not get the default value when I insert a new row, nor does the table save the default value when I insert a new records without specifying a value for it.
I still get the Null not allowed error on end edit.
When I open the SQL table and try insert, it works just fine.
Any ideas what's going on?