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

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

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