Re: SQR / Brio Portal Exceptions

[Don Mellen <donm@ONTKO.COM>]

On Wed, 14 Aug 2002, Steve Hearne wrote:

> Hello.  Can anyone give me an example of SQR code which can produce an
> exception that is able to be picked up on by Brio.Portal please?

begin-program
move 200000 to #max_good_value
begin-select
some_value  &some_value
   if &some_value > #max_good_value
      do make_exception
      add 1 to #errors
   end-if
from some_table
where something = 'XYZ'
end-select
end-program

!-----------------------------------------------------------
begin-procedure make_exception
if #errors = 1
   open 'output.properties' as 0 for-append record=32767:vary
   write 0 from 'rating=high-priority'
   write 0 from 'exception.default=on'
   write 0 from 'exception.default.text=Max value exceeded'
   close 0
end-if

You'll also have to set the property "can have exception" for the job.

HTH,
-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"