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

hi Fredericks, thanks for the reply.
I will try your advised.

Dan.

fredericks <free101_at_picusnet.com> wrote in article <36b41da3.0_at_news.itribe.net>...
> 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 Wed Feb 03 1999 - 07:56:48 CST