🚀 go-pugleaf

Hi

I am not sure if this question has been asked before , I have
searched hi and lo for an answer , but cannot get anything specific

The problem is

I have a MSSQL table with all columns defined as NOT NULL , with approriate
default values defined in the table def.

If I issue a insert into table (Field1,Field2) values ('a','b') from Query
Analyzer
all non specified fields in the insert update with their correct DEFAULT
values.

Using ADO (Adonis dataset) , adding a new record from a dbgrid into the
same table give a 'non null column cannot be updated with a null value' or
some
such equivelant message. If I set the table fields on MSSQL to allow NULLS ,
with
default values , the update goes through , however all non updated fields
are set to NULL , completely ignoring the table definitions default values
!.

I have tried to change marshall options to mrALL with no effect.

I am using the OLEDB provider for MSSQL , CBuilder 5 , Adonis Dataset

Puuuhhhlease could some one help me with this ?

Regards

Robi Kihm