Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

NULL/BLANK field value...

lucky_melucky_me Member Posts: 39
Hi everyone,
I am a newbie in oracle forms builder.I am trying to make an data entry form in Oracle Form Builder 6.I have to check that wheather a field is blank or not (any field on canvas).I tried it like this.....

If :block1.item1=NULL then
;
else
;
end if;

When i run the form then the 1st statement doesn't run even though it's blank.

HOw can i sort it out.
Please help me.
Thanks .

Comments

  • infidelinfidel Member Posts: 2,900
    : Hi everyone,
    : I am a newbie in oracle forms builder.I am trying to make an data entry form in Oracle Form Builder 6.I have to check that wheather a field is blank or not (any field on canvas).I tried it like this.....
    :
    : If :block1.item1=NULL then
    : ;
    : else
    : ;
    : end if;
    :
    : When i run the form then the 1st statement doesn't run even though it's blank.
    :
    : HOw can i sort it out.
    : Please help me.
    : Thanks .

    NULL can't be used in equality tests. Try "is NULL" rather than "= NULL" and see if that helps.


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

    [code]
    $ select * from users where clue > 0
    no rows returned
    [/code]

  • lucky_melucky_me Member Posts: 39
    Thanks infedal;
    It helped;
    Thanks alot; :-)




    : NULL can't be used in equality tests. Try "is NULL" rather than "= NULL" and see if that helps.
    :
    :
    : [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]
    :
    : [code]
    : $ select * from users where clue > 0
    : no rows returned
    : [/code]
    :
    :

Sign In or Register to comment.