Re: Print

[Ray Ontko <rayo@ONTKO.COM>]

Yes,

It appears that $sqr-report was introduced in 3.0 (looking back
through some of our old manuals.

Ray

> Hee Kok Hwa,
>
> I am wondering if your problem may have to do with the version of SQR that
> you are using.  I don't have the documentation for SQR version V2.27a, but I
> wonder if the predefined variable $sqr-report appears only in later
> versions.  (I cut and pasted your program below and it worked correctly for
> me.  However, I am using SQR version 3.0.13.3.)  Does anyone else have the
> manual for SQR 2.27a to back this theory up?
>
> --Steve
>
> ----------------------------------------------------------------------------
> >  Stephen C. Lorenz -- Systems Analyst  |  North Shore Community College  <
> >  slorenz@nscc.mass.edu                 |  One Ferncroft Rd, Danvers, MA  <
> ----------------------------------------------------------------------------
>
> On Sat, 6 Dec 1997, Hee Kok Hwa wrote:
>
> > Steve,
> > Some how I could not get any value for $sqr-report. Please refer to the
> > sample program below that run under Unix environment.
> > << Sample Program start. Sample program name : a.sqr >>
> > begin-report
> >     do a
> >     show 'Report variable 1 : ' $sqr-report
> > end-report
> >
> > begin-procedure a
> > print 'testing line' (1,1)
> > show 'Report variable 2 : ' $sqr-report
> > end-procedure
> > << Sample program end >>
> >
> > << Output of sample program start : a.sqr >>
> > $ sqr a / -f/user/temp/a.lis
> > SQR:  Structured Query Report Writer  V2.27a
> > Copyright (C) 1986-89  SQ Software  All Rights Reserved
> >
> > Report variable 1 :
> > Report variable 2 :
> > SQR:  End of Run.
> > $
> > << Output of sample program end >>
> >
> > I actually expected some output like "Report variable 1 :
> > user/temp/a.lis". Anything wrong with my program or my understanding?
> >
> > Hee Hee.
> > CWT Distribution Ltd.
> > Email : khhee@cwt.com.sg
> > Web : www.cwt.com
> > ----------
> > From: SQR-USERS; slorenz
> > Date: Friday, December 05, 1997 8:34AM
> >
> > Lawrence:
> >
> > You should be able to use the SQR predefined variable, $sqr-report, to
> > figure out the relative path to SQRTOP output.  Of course, you will need to
> > parse (a copy of) the $sqr-report variable to determine the actual path.
> > For example, the actual value of the $sqr-report variable (in UNIX) may be:
> >
> >        sales/annual/sqrtop.lis
> >
> >   And, you would need to substr that to:
> >
> >        sales/annual/
> >
> >   Then, you'd could concat "sqrlower.sqr" to the above path, to be:
> >
> >        sales/annual/sqrlower.lis
> >
> >   From there, you could concat a string to be used to CALL SYSTEM, like
> >   this:
> >
> >        sqr sqrlower username/password -Fsales/annual/sqrlower.lis
> >
> > I think would solve your problem.
> >
> > --Steve
> >
> >
> > On Fri, 5 Dec 1997, Wasserberger, Lawrence H. wrote:
> >
> > > I am trying to build an SQR (SQRTOP) that will use the "Call System" to
> > > drive a lover level SQR (SQRLOWER).  This will run under the Process
> > > Scheduler.
> > >
> > > All seems to work right with one exception.   I would like the LIS file
> > > from SQRLOWER to be in the same location as specified by the Process
> > > Schedule Request for SQRTOP.  Instead it appears in the same directory
> > > as the SQR source code.
> > >
> > > Is there some variable I could pick up and insert into the CALL SYSTEM
> > > command that would represent the output location specified by SQRTOP? .
> >
> >
> > ----------------------------------------------------------------------------
> > >  Stephen C. Lorenz -- Systems Analyst  |  North Shore Community College  <
> > >  slorenz@nscc.mass.edu                 |  One Ferncroft Rd, Danvers, MA  <
> > ----------------------------------------------------------------------------
> >
>

----------------------------------------------------------------------
Ray Ontko       |  Ray Ontko & Co  |  "Time for a new signature line."
rayo@ontko.com  |  Richmond, In    |  See us at http://www.ontko.com/