RE: [sqr-users] RE: $sqr-program

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

In my environment, display didn't write $sqr-program to the screen.

-----Original Message-----
From: Paul Hoyte [mailto:pi_hoyte@si-proservices.com] 
Sent: Tuesday, May 23, 2006 11:58 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] RE: $sqr-program


I ran this again to simulate your environment.  It appears that the SHOW
command only writes out to the log, while the display command writes to both
the screen and the log.
>----- ------- Original Message ------- -----
>From: "White . Denise" <DWhite@drc.com>
>To: <sqr-users@sqrug.org>
>Sent: Tue, 23 May 2006 09:26:29
>
>This is interesting.  I have to admit to some
>skepticism, but I tried
>it, and I got the same results as Steve.  The
>$sqr-program showed up in
>sqr.log, but not in the window.  I also tried
>taking out the
>double-quote character, since I never use that in
>SQR and wondered if it
>might be causing some glitch, and got the same
>result.  I also tried
>using display instead of show, and that turned out
>the same, as well.
>
>I am using SQRW on Windows XP Pro, also.
>
>Denise M. White
>EBS Programmer/Analyst III
>Dynamics Research Corporation
>------------------------------
>
>Message: 2
>Date: Mon, 22 May 2006 10:49:39 -0700
>From: "Alexander, Steven"
><Steven.Alexander@sanjoseca.gov>
>Subject: RE: [sqr-users] $sqr-program
>To: "'This list is for discussion about the SQR
>database
>        reportinglanguage       from Hyperion
>Solutions.'"
><sqr-users@sqrug.org>
>Message-ID:
>        
><62AFC819CCF3D611827A00065B3F7981101F9447@sj_exchan
>ge.ci.sj.ca.us>
>Content-Type: text/plain
>
>Maybe the bug is restricted to SQRW (for Windows XP
>Pro).
>
>-----Original Message-----
>From: Paul Hoyte
>[mailto:pi_hoyte@si-proservices.com]
>Sent: Monday, May 22, 2006 4:50 AM
>To: 'This list is for discussion about the SQR
>database
>reportinglanguagefrom Hyperion Solutions.'
>Subject: RE: [sqr-users] $sqr-program
>
>Not to beat a dead horse, but this is what I get
>when I run the program
>as you wrote it below:
>
>line 1: "c:\student\dummy1.sqr"
>line 2: "c:\student\dummy1.sqr"
>line 3: "*c:\student\dummy1.sqr*"
>line 4:  21
>line 5: c:\student\dummy1.sqr
>
>
>Appears in my log file as well as on the display
>(running SQR
>Developer). 
>
>
>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: Friday, May 19, 2006 6:10 PM
>To: 'This list is for discussion about the SQR
>database
>reportinglanguagefrom Hyperion Solutions.'
>Subject: RE: [sqr-users] $sqr-program
>
>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.
>
>_______________________________________________
>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