[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Calling an SQR file from another SQR files multipletimes
- Subject: [sqr-users] Calling an SQR file from another SQR files multipletimes
- From: "Kim Meyrowitz" <kmeyrowitz@hotmail.com>
- Date: Mon, 10 Apr 2006 11:20:02 -0400
- Bcc:
- Delivery-date: Mon, 10 Apr 2006 11:22:08 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
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