RE: [sqr-users] Calling an SQR file from another SQRfilesmultipletimes

["Kim Meyrowitz" <kmeyrowitz@hotmail.com>]

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