Re: [sqr-users] Calling an SQR file from anotherSQR filesmultipletimes

[Donald Mellen <donm@ontko.com>]

Well, I'm not fully clear on what you're trying to accomplish in the 
end, but...

If you don't need the viewer invoked after each call to your sub-sqr, 
get rid of the -ziv flag

If you want the viewer invoked after each call to your sub-sqr, try 
adding the "wait" option at the end of your "call system using" command 
(not sure if this will recognize the viewer running as part of the call 
or not).

If you want the viewer invoked after each call to your sub-sqr and the 
"wait" option doesn't work, try adding an input in-between the "call 
system using" commands.  Prompt something like "close viewer and then 
hit enter for next XXXX". 

Would one of these accomplish what you're after?

HTH,
Don

Kim Meyrowitz wrote:
> The file that could potentially be appended to is a stand-alone file 
> that creates a formatted report using the print command instead of the 
> write command.  So it can't always be appended, since it will be used 
> by my calling program and then by itself (where I don't want to append).
>
>
>> From: "Knapp, Richard" <KnappR@umsystem.edu>
>> Reply-To: "This list is for discussion about the SQR database 
>> reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>> To: "This list is for discussion about the SQR database 
>> reportinglanguage fromHyperion Solutions." <sqr-users@sqrug.org>
>> Subject: RE: [sqr-users] Calling an SQR file from another SQR 
>> filesmultipletimes
>> Date: Mon, 10 Apr 2006 10:28:11 -0500
>>
>>
>> If what you want to do is append to an sqr program and then call it from
>> the same program that did the appending, open it for-append, write to
>> it, close it then call it.
>>
>> Richard Knapp
>> Database Programmer/Analyst
>> Institutional Research and Planning
>> University of Missouri System
>> 573-882-8856
>> knappr@umsystem.edu
>> -----Original Message-----
>> From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
>> [mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
>> Kim Meyrowitz
>> Sent: Monday, April 10, 2006 10:20 AM
>> To: sqr-users@sqrug.org
>> Subject: [sqr-users] Calling an SQR file from another SQR files
>> multipletimes
>>
>> I have been successful calling a SQR file from another SQR file, but I
>> can't
>> do it more than one time.  What happens is that the SQR view opens and
>> when
>> it calls the file a second time it can't open the file because the
>> viewer is
>> already open.
>>
>> How can I call it multiple times or how can I append to this file?
>>
>> Here's a code snippet I have been testing with:
>>
>>
>>     Let $My_Command = 'SQRW Test_file.sqr openxxs/openxxs@MYDB "' ||
>>             $Parm1 || '" "' || $Parm2 || '" ' ||
>>             '-I \BINW\ -M \dfltover.sqf -nolis -ziv -debug
>> -A'
>>
>>
>>     !First call to file
>>     Call System Using $My_Command    #Status
>>
>>     Let $Parm1 = 'OM TESTCONSTRAINT'
>>     Let $Parm2 = 'OM TESTCONSTRAINT'
>>
>>
>>                 !Second call to same file (different parameters)
>>     Let $My_Command = 'SQRW Test_file.sqr openxxs/openxxs@MYDB "' ||
>>             $Parm1 || '" "' || $Parm2 || '" ' ||
>>             '-I \BINW\ -M \dfltover.sqf -nolis -ziv -debug
>> -A'
>>
>>     Show $Parm1
>>     Show $Parm2
>>     Show $My_Command
>>
>>     Call System Using $My_Command    #Status
>>     Show 'Status:  ' #Status
>>
>>     Show 'Done calling'
>>
>> Thanks!
>> Kim
>>
>>
>>
>> _______________________________________________
>> 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
>


-- 
-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users