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/
>
>
>