Re: Working with Null values of database in SQR

[Parijat Sahai <parijatsahai@HOTMAIL.COM>]

Hi all,

Thanks for the reponse to my query (no pun intended).

My problem was how to specify null value in an SQR variable, i.e., my
query would be
begin-select
my_column_1
from my_table
where my_column_2 = $column2-value
end-select
I wanted to be able to specify at runtime the value of $column2-value
to be either 'null' or any valid string.
As one of you suggested, specifying $column2-value = '' would work fine.
Thanks. It works. Another method would be to write following code:
let $exp-col2 = 'is'
let $column2-value = 'null'
begin-select
my_column_1
from my_table
where my_column_2 [$exp-col2] [$column2-value]
end-select
Now I can change $exp-col2 and $column2-value at runtime to select on a
specific value or on 'null'.

Parijat

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com