Re: SQR Not finding Rows

[mahesh bhor <mgbhor@HOTMAIL.COM>]

Mark ,
We once faced such problem . RDBMS - Informix ( -- is comment )
My code was something like this -
begin-select
count(*)
from  ps_dept_tbl
where [$condn1]
--and  deptid like '01%'
and [$condn2]
and [$condn3]
end-select

The condition for deptid was put in for testing & for actual run instead
of '!' , '--' was put as comment . Because of this the cursor built was
'select count(*) from ps_dept_tbl where [$condn1] --and ..'.
All conditions after '--' were never executed since all statements were
considered as comments .
Maybe you can run the SQR with -S option to get the cursor and check the
cursor .
Hope this helps .

Mahesh

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