Re: Forms 4.0 - Query with NULL value?
From: Gary Myers <101355.3556_at_CompuServe.COM>
Date: 1995/12/22
Message-ID: <4bf22t$1nm$1_at_mhafn.production.compuserve.com>#1/1
Date: 1995/12/22
Message-ID: <4bf22t$1nm$1_at_mhafn.production.compuserve.com>#1/1
You should be able to pick up only those rows where the field is null be
by explicitly adding it to the default where clause on the block
IE (table.column = :block.column) or (:block.column is null and table.column
is null)
If you prefer, you could alter this so that null values are only returned
where the field is set to *NULL* or somesuch value.
Gary
-- Gary Myers, Analyst/Programmer, Kaisha Technology, West of EnglandReceived on Fri Dec 22 1995 - 00:00:00 CET