Re: Print

[Bob Harvey <bharvey@CONNECT1.REACH.NET>]

I have a old manual (V2 - 1990 vintage) which does NOT have the reserved
variable$sqr-report.

Could it be that this did not come into use until V2.5?


>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  <
>> ----------------------------------------------------------------------------

Bob Harvey