-----Original Message-----
From: Rohit Gupta [mailto:rohit@...]
Sent: 08 June 2001 10:00
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Null

>Not a feasable solution with literally thousands of filters assigned
>everywhere. Besides the problme is the null. If a field is left null, its
>order in the search is not teh same as blank or 0.

>Using a statement such as (xx > 0) fails to find them and so does (xx<=
>0).... it is illogical. It should be in one or the other set.

Not so. Null means its not a value or unknown, so it can't be in either set.
This is something you need to consider at design time. Defining the column
as not null and defaulting to 0 might be a solution, depending on what your
problem is. Jo Celko gives a good description of the problems of allowing
nulls in one of his books. Can't remember which one off hand.

Ray Drew
CIAUK

>Unfortunately the defaults in Interbase do not work when using IBO.

>IBO should save '' and 0 for nulls in strings and integers.

>----- Original Message -----
>From: "Woody" <woody.tmw@...>
>To: <ib-support@yahoogroups.com>
>Sent: Friday, 8 June 2001 12:08
>Subject: Re: [ib-support] Null


> simply put in
>
> where (Field is null or Field < 0)
>
>
> HTH
> Woody
>
> ----- Original Message -----
> From: Sandeep
> To: ib-support@yahoogroups.com
> Sent: Thursday, June 07, 2001 7:07 PM
> Subject: [ib-support] Null
>
>
> I have some columns where I have some null values. When I query
> the table with condition like [field < 0] i don't get the records with
> null values. I have prdefined conditions in my application and I don't
> want to change these. How do I get around this problem.
>
> Thanx in advance
>
> Sandeep
>
> Software Developer
> CFL
> sandeep@...
> http://www.cfl.co.nz
>
>
> Yahoo! Groups Sponsor
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/