Re: HELP !!...problem with NOT NULL fields in where ..FORMS 3.0

nakkala_at_cs.tamu.edu (Venkatesh Nakkala) writes:

> Howdy Everyone out there,  

> I have this problem with the WHERE part of the ORDERING
> clause for a Block..the entry in the .inp file looks like this

>          


>	  ORDERING


>	  <<<

>	   where key_1 = :blkname.key_1

>	   and   key_2 = :blkname.key_2

>	   and   possibly_null_fld = :blkname.possibly_null_fld

>	   >>>


       Try replacing the last phrase with:

           and   nvl(possibly_null_fld,'$$NULL$$') = 
                 nvl(:blkname.possibly_null_fld,'$$NULL$$')

       I usually use '$$NULL$$' for CHAR fields because it it 
       unlikely to be an actual value present in any field. 

       Remember that a null value evaluated directly by any comparator
       (= < > <> != ...) will ALWAYS return FALSE.
        

>-----------------------------------------------------------------------------


>		     Venkatesh  Nakkala    nakkala_at_cs.neuron.tamu.edu 


> Off : (409)845-5481                       Res : (409)268-7404
> Dept. Of Comp Sci.,Texas A & M Univ.      Fax : (409)847-8578