Re: Need HELP : Form 4.5 Alert and Trigger Problems for aircraft

DAN See the posting I just submitted in comp.databases.oracle.tools with subject :

re: Please help on query question.
from: fredericks

The solution requires the same approach.

Put the query into a function ..

HTH Mark

dan_klu wrote in message <01be4ca7$aa9b33a0$5315bcca_at_default>...
>
>Hi there....the Oracle experts
>
>I am new using Oracle only a few weeks, but with some
>Informix background with both 4gl and Isql. Please
>help me how to fix this alert and trigger problems.
>my main logic/psudeocode is as follows :-
>
> select count(*) the aircraft without registration
> number for today;
> if the count > 1 (at least one aircraft exist) then
> display meassage ('the will be x numbers of aircraft
> without registration number today');
> and
> display flight_no, atmsetad, A/D, D/I, time in hr, mi, etc;
> else
> display message ('there is NO flight without registration
> number today');
> end if;
>
> both the sql's for the count(*) and detail flight works fine when
> I tested in the sqlplus but not in the PL/SQL editor & trigger in
> the form45
Received on Sun Jan 31 1999 - 03:10:46 CST