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

["Paul Hoyte" <phoyte@sharidionne.com>]

There may be data, yes.  When you run it outside of SQR you actual type
in the values for the where clause.  Might want to take a look at the
values that are being populated within the SQR just to make sure.  Also
might want to make sure that the procedure is actually being called.  If
all of these check our then we have a different problem.....

Paul Hoyte 
Sharidionne Inc. 
(248) 559-6868 
(248) 559-6875 - Fax 
(248) 752-6970 - Cell 
Email: phoyte@sharidionne.com 



-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org] On
Behalf Of rachel fuller
Sent: Saturday, May 17, 2003 2:11 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] SQR not executing sql statements


It's definitely not that there is no data. I can execute the sql in
Oracle 
with the parameter values from the SQR and get results, so I know that
there 
is a row out there on the database that I am trying to select. It just 
doesn't seem to be working through the SQR program.


>From: "Paul Hoyte" <phoyte@sharidionne.com>
>Reply-To: sqr-users@sqrug.org
>To: <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] SQR not executing sql statements
>Date: Sat, 17 May 2003 14:00:53 -0400
>
>Rachel:
>
>If the show statements do not reflect the statements within the select,

>then it means that the select is not getting executed. This could 
>possibly be caused by the where clause having the limiting values that 
>do not return any rows from the table.  If there are no rows returned 
>as a result of the select, the end-select is executed immediately and 
>any SQR statements within the select are not executed.  Might want to 
>show the where clause limiting values before the select executes so you

>can see exactly what is going into the select.  Regards,
>
>Paul Hoyte
>Sharidionne Inc.
>(248) 559-6868
>(248) 559-6875 - Fax
>(248) 752-6970 - Cell
>Email: phoyte@sharidionne.com
>
>
>
>-----Original Message-----
>From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org] On 
>Behalf Of rachel fuller
>Sent: Saturday, May 17, 2003 1:34 PM
>To: sqr-users@sqrug.org
>Subject: [sqr-users] SQR not executing sql statements
>
>
>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
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

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

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