RE: [sqr-users] $sqr-program

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

I should have been more precise.  It looked like the show command was
working and I saw the literal text in the log file before and after the
$sqr-program value.  It's just that the $sqr-program value was shown as
null.

But your reply got me thinking.  I was assuming that the show command worked
perfectly on the $sqr-program variable.  Well, maybe the show command or the
$sqr-program variable are not what they seem.  Look at this:

begin-program
  show 'line 1: "' $sqr-program '"'
  let $x = $sqr-program
  show 'line 2: "' $x '"'
  let $x = '*' || $sqr-program || '*'
  show 'line 3: "' $x '"'
  let #x = length($sqr-program)
  show 'line 4: ' #x edit 999
  display 'line 5: ' noline
  display $sqr-program
end-program

produces the following log file:

line 1: "c:\sqr\abs003.sqr"
line 2: "c:\sqr\abs003.sqr"
line 3: "*c:\sqr\abs003.sqr*"
line 4:  17
line 5: c:\sqr\abs003.sqr

BUT, the display window contains:

line 1: ""
line 2: ""
line 3: "*c:\sqr\abs003.sqr*"
line 4:  17
line 5:

So this is a bug in the show and display commands.  Thank you, Paul, for
pointing me to the answer, and thank you, Kevin, for research that
strengthens my theory.  (Kevin demonstrated that the value was in
$sqr-program, and that the print command could output it successfully.)

The reason this came up was that I was searching the Peoplesoft Process
Definition table for the the process definition that corresponded to this
program.  The selection returned no rows and I tried to debug it by using a
show statement.  Now I'm thinking that my debug tool (show or display) was
the second problem.  The first problem is that I have to strip the path and
extension, and uppercase the filename before I use it for the selection.


-----Original Message-----
From: Paul Hoyte [mailto:pi_hoyte@si-proservices.com] 
Sent: Friday, May 19, 2006 1:30 PM
To: sqr-users@sqrug.org
Subject: RE: RE: [sqr-users] $sqr-program


Steve:

THe result of the show command goes to the log file.  If you look there and
its still null, then the format of the show command needs to be checked.
There are no special flags or include files that are needed to use the
reserved variable.  Unless, PSOFT has removed the variable from their
version of the SQR executable, you should be able to see the value..........
Another thing you might try is just to show some other value or variable to
make sure that the show command is indeed working.......


>----- ------- Original Message ------- -----
>From: "Alexander, Steven"
><Steven.Alexander@sanjoseca.gov>
>To: "'This list is for discussion about the SQR
>database reportinglanguage
>        from Hyperion Solutions.'"
><sqr-users@sqrug.org>
>Sent: Fri, 19 May 2006 09:54:36
>
>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.c
>om@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

_______________________________________________
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