RE: [sqr-users] $sqr-program

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

It doesn't work for me.  Is there something in the SQR command line that I'm
including or omitting that affects this variable?  Or is there an include
file I need?

\\Hera\Psoft8\Psoft815\PROD\bin\sqrps\sqr\ora\BINW\sqrw.exe
"c:\sqr\abs003.sqr" PROD/********@**** -B1000 -C -D -Fc:\sqr\ 
-I:\psoft815\prod\sqr\csj_sqr\;h:\psoft815\prod\sqr\ -Oc:\sqr\abs003.log -S
-ZIFc:\sqr\pssqr.ini -debugt PROD

-----Original Message-----
From: Paul Hoyte [mailto:pi_hoyte@si-proservices.com] 
Sent: Thursday, May 18, 2006 6:34 PM
To: 'This list is for discussion about the SQR database
reportinglanguagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] $sqr-program

Steve:

begin-program


    show 'SQR-PROGRAM.......'  $sqr-program


end-program 

This works.........



Paul Hoyte
(248) 752-6970
pa_hoyte@si-proservices.com

-----Original Message-----
From: sqr-users-bounces+pi_hoyte=si-proservices.com@sqrug.org
[mailto:sqr-users-bounces+pi_hoyte=si-proservices.com@sqrug.org] On Behalf
Of Alexander, Steven
Sent: Thursday, May 18, 2006 4:07 PM
To: 'This list is for discussion about the SQR database
reportinglanguagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] $sqr-program

Thanks for the suggestions, Roger and Peter, but I had this problem in the
following code:

Begin-program
  Show 'SQR-PROGRAM = "' $sqr-program '"'
End-program




-----Original Message-----
From: Roger.Harris@certegy.com [mailto:Roger.Harris@certegy.com]
Sent: Thursday, May 18, 2006 11:02 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] $sqr-program

My first thought is that you are trying to reference $sqr-program in a local
procedure. If that is the case you will need to use $_sqr-program as with
all global variables in a local procedure,





|---------+---------------------------------------------------->
|         |           "Alexander, Steven"                      |
|         |           <Steven.Alexander@sanjoseca.gov>         |
|         |           Sent by:                                 |
|         |           sqr-users-bounces+roger.harris=certegy.co|
|         |           m@sqrug.org                              |
|         |                                                    |
|         |                                                    |
|         |           05/18/2006 01:55 PM                      |
|         |           Please respond to "This list is for      |
|         |           discussion about the SQR database        |
|         |           reporting  language from Hyperion        |
|         |           Solutions."                              |
|         |                                                    |
|---------+---------------------------------------------------->
 
>-----------------------------------------------------------------------
>----
------------------|
  |
|
  |       To:       "'This list is for discussion about the SQR database
reportinglanguage  from|
  |        Hyperion Solutions.'" <sqr-users@sqrug.org>
|
  |       cc:
|
  |       Subject:  [sqr-users] $sqr-program
|
 
>-----------------------------------------------------------------------
>----
------------------|




The SQR manual says that $sqr-program is supposed to contain the name of the
source file being executed.  I'm getting the null string.  Any ideas why?

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






----------------------------------------------------------------------------
--
This message contains information from Certegy, Inc which may be
confidential and privileged.  If you are not an intended recipient, please
refrain from any disclosure, copying, distribution or use of this
information and note that such actions are prohibited.  If you have received
this transmission in error, please notify by e:mail postmaster@certegy.com.
============================================================================
==


_______________________________________________
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



_______________________________________________
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