RE: [sqr-users] Check the existance of table in SQR

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

One easy way would be to create the tables in a begin-sql block and add an 
on-error proc  to trap errors.  You can then check in
your on-error proc if the error was that the table already exists.  Or you 
could just try to drop the temp tables and ignore any
errors.
Steve.

-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf 
Of Sanjay Sambhe
Sent: Wednesday, 19 September 2007 6:08 PM
To: 'This list is for discussion about the SQR database reporting languagefrom 
Hyperion Solutions.'
Subject: [sqr-users] Check the existance of table in SQR

Hi All,

Hope you are doing good..

I need to modify a sqr . I need to check the existance of temporary tables 
(which should be created by sqr code if not exists in
backend). Could you pls suggest me How to check the existance of temp tables 
through sqr code ?

Thanks and regards
Ss

_______________________________________________
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