Subject Re: [ib-support] Re: Helen: Low Selectivity Problem
Author Helen Borrie
At 01:31 AM 27-08-02 +0000, you wrote:

>Could you possibly point me to some info regarding triggers and RI?
>I'm quite new to FB / triggers / sp's

There is an article in the IB Phoenix documentation area about writing
procedures and triggers.

>I will research CREATE EXCEPTION like Helen suggested.

Just not to put you crook, you CREATE the exception in metadata and use it
in SPs and triggers when handling the exception condition - what it does is
provide a try---catch mechanism so that you can silently handle an
exception or alternatively end processing and return the message defined by
the exception back to your client.

For some unfathomable reason, exception messages are limited to 78
characters. (Makes a note to file a feature request....)