RE: [sqr-users] Error Handling In select statements in SQR..

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

My understanding is that the SQR compiler evaluates select statements and
reports errors when it compiles the program ... if it can.  If the select
statement includes dynamic variables, it won't be evaluated until it
executes.  That's the case that needs the "on-error" clause.

The "begin-sql" paragraphs can always benefit from the "on-error" clause,
because CHANGING data in the database can cause errors in processing that
wouldn't be apparent during the compile stage.

-----Original Message-----
From: sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org
[mailto:sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org] On
Behalf Of Knapp, Richard
Sent: Wednesday, February 21, 2007 7:15 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Error Handling In select statements in SQR.. 


Whenever you might want to evaluate the error and proceed with the
program's processing or perhaps capture some of the data in the record
that caused the error.

Richard Knapp
EAS - Data Warehouse Group
University of Missouri
615 Locust Street  #200
Columbia, MO 65201
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
senthilkumar periyasami
Sent: Wednesday, February 21, 2007 3:39 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Error Handling In select statements in SQR.. 

When do we need error handling in select statements in SQR?
   
  Please help me....Senthil 

                                
---------------------------------
 Here's a new way to find what you're looking for - Yahoo! Answers 

_______________________________________________
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