> 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.
> Unfortunately the defaults in Interbase do not work when using IBO.

If you don't want the NULL's just replace them?

UPDATE x
SET y = 0 ( or y = '' )
WHERE y is NULL

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

You just set these up as the default WITHIN IBO. When records are appended the
correct default can then be used. I have the same defaults set in the database
as well, but no problems following this convention when using IBO.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services