Re: HELP !!...problem with NOT NULL fields in where ..FORMS 3.0
From: I.Vinikovetsky <ilia_at_wescom.kharkov.ua>
Date: Sat, 27 Feb 1993 20:14:15 GMT
Message-ID: <1993Feb27.201415.25061_at_wescom.kharkov.ua>
Date: Sat, 27 Feb 1993 20:14:15 GMT
Message-ID: <1993Feb27.201415.25061_at_wescom.kharkov.ua>
Hi!
Let you modify your ORDERING clause in such a way
where ...
and ...
and ((:blkname.possibly_null_fld is null and
possibly_null_fld = :blkname.possibly_null_fld) or (:blkname.possibly_null_fld is null and
possibly_null_fld is null))
The comparison of null and not null values alvays result, that one hardly can predict. It's better to devide them in separate conditions.
Ilia Vinikovetsky, WESCOM inc., Kharkov, Ukraine Received on Sat Feb 27 1993 - 21:14:15 CET