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

[Les Hancock <les_hanc@yahoo.com>]

You might try showing the values in the where clause. 
Like this:

show 'before select'
show '$value1 = ' $value1
show '$value2 = ' $value2
show '$value3 = ' $value3
show '$value4 = ' $value4

begin-select
a.emplid
        let $emplid = &a.emplid
        show 'emplid: '$emplid
        from sysadm.ps_job a
where a.emplid = $value1
and a.action = $value2
and a.action_reason = $value3
and a.effdt = $value4
end-select


Then see if you really have those rows with $value1
thru $value4 in your database using SQLPlus or SQL
Worksheet.


HTH,

Les


--- rachel fuller <fullerlr@hotmail.com> wrote:
> 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


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

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