Re: How Do I define a the -f .lis file from within a SQR

[Tony DeLia <tdelia@EROLS.COM>]

Hi Sunil,

   Try the following...

...
input #file_no 'Enter Legacy File No' type=integer
let $Rpt_name = $sqr-program || edit(#file_no,'099') || '.lis'
new-report $Rpt_name
...

This will assign a name of 'TCUCV101.LIS' assuming the SQR program name
is TCUCV.SQR and the user entered 101 as the File Number...

       Tony DeLia

PS - You can also override the directory path by assigning it within the
$Rpt_name variable...

Shenoy, Sunil wrote:
>
> I am trying to define the default -f .lis file from within the SQR program.
> Is there any way to do this.
> Specifically, I am asking for a file # input and I want to append that # to
> the default .lis file that I have defined at the command line.
>
> e.g  (for TCUCV.sqr, the default lis file is TCUCV.lis)
>
> begin-program
>
> input #file_no 'Enter the Legacy File No.' type = integer
>
> Do processing
> Do printing
>
> end-program
>
> I want the .lis file to be TCUCV101.lis if I enter 101 for #file_no,
> TCUCV150.lis if I enter 150 and so on.
>
> Any help or hints is greatly appreciated.
>
> The SQR version/details that I am working on is as follows
>
> SQR/4.3.2/PC/Windows NT 4.0/Oracle 7.3.4/Sep 14 1998
>
> Thanks
>
> Sunil G. Shenoy
> TCU

--
Tony DeLia
AnswerThink Consulting Group
PeopleSoft Solutions Practice - Delphi Partners
tdelia@erols.com
http://www.sqrtools.com