[sqr-users] SQR not executing sql statements

["rachel fuller" <fullerlr@hotmail.com>]

I am hoping that someone can help. I created a new sqr program that is to be 
run from a page in PeopleSoft. I believe that I have set everything up 
correctly because I am able to run the SQR from within PeopleSoft and it 
runs to success.

However, the SQR is not executing any of the sql. I know that the sqr is 
running as it will execute any show statements - however, I am trying to 
select from a table and it the program doesn't seem to be executing the sql

sql statement -->

show 'before select'
begin-select
a.emplid
        let $emplid = &a.emplid
        show 'emplid: '$emplid
        from sysadm.ps_job a
where a.emplid = value
and a.action = value
and a.action_reason = value
and a.effdt = value
end-select

show 'after select'

---
The log file will show the two before and after show statements, but not the 
one within the sql and I know that there is data to be selected as I can run 
the sql in Oracle directly and get the correct results.
I am not sure if the problem is with the setup of the new page or with the 
actual sqr. I don't think it's the setup of the objects because I can access 
the run control and can run the program.

This is running on an NT server, oracle database.

Any suggestions would be helpful.
Thanks!

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users