Re: SQR Not finding Rows -Reply

[Mark Kraft <kraftm@GUNET.GEORGETOWN.EDU>]

This was the problem, thanks for the help.  I had given it some thought
and the only difference was the comments, but I know they were in
there before when it was running fine.  I took the comments out of the
SQR and everything is running like a champ.  Thanks Again for
everyone's help.

Mark Kraft
kraftm@gunet.georgetown.edu

>>> mahesh bhor <mgbhor@HOTMAIL.COM> 01/06/99 05:00pm >>>
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