🚀 go-pugleaf

I have some more data on this problem

The null values can be caused by doing this
DataSet->FieldValues["FieldName"] = "";

This used to work fine in the BDE , but not with ADO / Adonis Components.
Why ????? , a "" is an empty string , NOT  a NULL (as far as I understand ?)


Is there a simple fix for this , as I really wish to avoid having to put in
tons of code
just to fix this.

Regards

Robi




"Robi Kihm" <robi_kihm@yebo.co.za> wrote in message news:3ce7b2a9_2@dnews...
> 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
>
>
>
>