[sqr-users] RE: SQR not executing sql statements

["White, Denise" <DEWhite@vicr.com>]

Hi Rachel,

You might want to try forcing the date into the correct format.  Dates can be 
tricky, even if you think you have the right format.  I would use something 
like:

and a.effdt = to_date($value,'mmddyyyy')

Of course, substitute the actual format of your date string for what I have put 
in my example.  Also, is it necessary to use the 'sysadm.' prefix on your table 
name?  I've never had to do that myself, so I don't know if there could be any 
issues caused by that.  Your 'from' clause should really start in the first 
column, but I tested and having it start in another column did not cause a 
problem.

Denise M. White
Sr. Software Engineer
Vicor 
--__--__--

Message: 1
From: "rachel fuller" <fullerlr@hotmail.com>
To: sqr-users@sqrug.org
Date: Sat, 17 May 2003 13:33:59 -0400
Subject: [sqr-users] SQR not executing sql statements
Reply-To: sqr-users@sqrug.org

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!

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