At 05:20 PM 08-07-01 +0000, you wrote:

>--- In IBObjects@y..., "Kaputnik" <delphi@k...> wrote:
> > Did you check fort he BLANK IS NULL property in the FieldPorperties
>of
> > your query?
> >
>Yes, and it's not checked (in ColumnAttributes the property is
>unchecked). So it does NOT consider blank as null.

See what happens when you check BLANKISNULL -True and then -False. I think what might be happening is that it ignores a null entry for BLANKISNULL...will only add that attribute if it is explicitly made True or False.

Regards,
Helen

>In any case your suggestion makes clear that Jason has considered the
>problem of the meaning of blanks varchars regarding nulls, and there
>must be something wrong in IBO about that (seeLester Caine reply).
>Thanks
>Marco Menardi
>
>
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________