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

["Knapp, Richard" <KnappR@umsystem.edu>]

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