Kind of handy

Like extra pizza topping: Null, 'Bacon', 'Cheese'

Null = No extra topping. Subsequently taking advantage
of the 'no exist' behavour of the Null value.

Best Regards
Hans

===============================================================



Helen Borrie wrote:

>
> Is there any sense in having a lookup dataset that is capable of returning a NULL value ????
>
> I hope this is not a feature request!
>
> fwiw,
> Helen
>
> At 09:05 AM 11-08-01 -0300, you wrote:
> >HelpI have noted in IBO3.6De a problem when using tib_lookupcombo and your dataset used to drop down contains null values.
> >
> >For sample I have a Table1:
> >Nr Integer Formula varchar(3)
> >1 FRA
> >2 BRA
> >3 (Field is NULL)
> >4 CRA
> >....
> >....
> >After I order by field: "Formula", I noted:
> >
> >1. If I use a dataset from this table containing null values, the incremental search doesn't find some records. There are others where incremental search works well.
> >
> >2. If I use a dataset from this table containing no null values, the incremental search works well in all cases.
> >
> >Regards,
> >Luiz.
> >
> >
> >
> >
> >[Non-text portions of this message have been removed]
> >
> >
> >
> >
> >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
> _______________________________________________________
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/