RE: [sqr-users] sqr compile

[Bob Stone <bstone@fastenal.com>]

I concur.  code a stop first, the code will go through the compile stage,
get to the execution stage and stop itself before any processing starts.  Or
do a goto at the beginning that goes to the end.  just skip all execution



-----Original Message-----

As previously suggested code a stop before any processing occurs.




-----Original Message-----
From: sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org
[mailto:sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org] On Behalf
Of Kaithi, Murali
Sent: Thursday, September 09, 2004 9:01 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] sqr compile


That's what my problem is. Rollback will be of no use for me as I have
truncates in my program.
I am still waiting on for proper solutions from you guys to compile the
program without actually executing it.

Thanks,
Murali


-----Original Message-----
From: sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org
[mailto:sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org]On
Behalf Of Dattatraya Shetty
Sent: Thursday, September 09, 2004 8:51 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] sqr compile


I think only problem with Rollback is that if the tables have been
truncated and not deleted then it is of no use. 

--- "Sapitan, Mary Ann (MG)" <MSapitan@dow.com> wrote:

> I think you could try putting a rollback command at the end of the
> sqr and still run it so as not to have the changes be committed to
> the database.
> Anyway, if your sqr would have syntax errors, it wouldn't reach the
> end of the program and roll back anyway. :)
> 
> 
> 
> Thanks,
> Ma-an Sapitan
> * (632) 841-0111 loc. 4549
> 
> 
> -----Original Message-----
> From: Kaithi, Murali [mailto:Murali.Kaithi@spencergifts.com] 
> Sent: Wednesday, September 08, 2004 11:49 PM
> To: This list is for discussion about the SQR database
> reportinglanguage from Hyperion Solutions.
> Subject: [sqr-users] sqr compile
> 
> 
> I want to compile a sqr for any syntax errors etc without actually
> executing the program. I dont want the program to execute as it has
> lot of database truncates and updates. I just need a way to compile
> the sqr. Any ideas?
> 
> 
> Thanks,
> Murali

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