Re: SQL*Forms 3.0 question

From: <fgreene_at_hayes.com>
Date: 17 Oct 93 07:41:00 EDT
Message-ID: <8117.2cc0f70c_at_hayes.com>

In article <4303_at_blue.cis.pitt.edu>, paubh4+_at_pitt.edu (Brian C Hogue) writes:
> Hi There,
>
> I'm fairly new to SQL*Forms 3.0. Is there a simple way to shut
> off or disconnect certain exceptions. For instance, I have a trigger
> which goes out and queries a table. It may or may not find records to
> return from the table. In this case, I don't consider not finding any
> records a problem, but the NO_DATA_FOUND exception takes over and my
> trigger stops executing.
>

inside yourtrigger, use this text

BEGIN                                                    -- start block
    SELECT your_field                                    -- the select

    INTO :block_name.your_field
    FROM the_table
    WHERE your_condition = :block_name.your_condition;

EXCEPTION                                                -- error conditions
    WHEN   NO_DATA_FOUND THEN
           NULL;
END;                                                     -- end the block

 ----------------------------------------------------------------------------
 | Frank Greene DELPHI SYSTEMS Inc    |          _/_/_/  _/_/_/             |
 | Telephone [615] 458-6032           |           _/_/    _/_/              |
 | Internet 74200.427_at_compuserve.com  |          _/_/    _/_/  _/_/_/       |
 | Compuserve 74200,427               |         _/_/    _/_/    _/_/        |
 | 324 Ootsima Way                    |        _/_/    _/_/    _/_/         |
 | Loudon, TN 37774                   |       _/_/_/  _/_/_/  _/_/_/        |
 ----------------------------------------------------------------------------
 |         Of course, any opinions or suggestions are strictly my own       |
 ----------------------------------------------------------------------------

Received on Sun Oct 17 1993 - 12:41:00 CET