Eustachio,

just keep in mind:

/Mantra on
"Null is a state, not a value"
/Mantra off


Luc.

"Eustachio, Peter Czarnecki" schrieb:

>
> Hello,
>
> many thanks for your help!
>
> I have understand (I hope) the difference between blanks
> and nulls.
> For testing I have tried the followings update SQLs for
> MyField defined as MYDOMAINCHAR NOT NULL
>
> Update MyTable set MyField = '';
>
> This update is accepted and I have a "null" field.
>
> Update MyTable set Myfield = null;
>
> Only in this case I have the validation error from InterBase and
> the update can't be posted. (I have spend so many time for
> discover this subtil non-userfriendly difference!).
>
> Regards
>
> Peter Czarnecki
> Eustachio SA
>
> ----- Original Message -----
> From: "Jason Wharton" <jwharton@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Monday, October 15, 2001 6:29 PM
> Subject: Re: [IBO] Posting nulls into NOT NULL fields.
>
> > > > If you want a NULL then explicitly set the IsNull property
> > > > or call the Clear method of the field.
> > >
> > > if so, what's the meaning of the BLANK IS NULL property?
> >
> > Notice the word "explicitly" which means regardless of the BLANKISNULL
> > setting, a NULL will be assigned to the column.
> >
> > Regards,
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/