Re: Q: Forms 4 - PL/SQL Trigger Execution
Date: Fri, 16 Sep 1994 13:34:36 GMT
Message-ID: <kenho.47.2E799EEB_at_hk.super.net>
In article <1994Sep14.102736_at_ecid.cig.mot.com> hancockr_at_ecid.cig.mot.com (Robbie J Hancock) writes:
>From: hancockr_at_ecid.cig.mot.com (Robbie J Hancock)
>Subject: Q: Forms 4 - PL/SQL Trigger Execution
>Date: 14 Sep 1994 09:37:32 GMT
>HELP !!
>I have a form that executes a host shell script that runs a SQL script to
>produce a report on KEY-COMMIT.
>The problem is that the report takes a while to run and I would like to inform
>the user that it is running when they commit the form, currently it just sits
>there until the report has finished.
>I have tried a :-
> MESSAGE ('Running Report - Please Wait ...');
>statement before the host call in the KEY-COMMIT Trigger, but as far as I can
>see FORMS has to process the whole PL/SQL block (including Host call) before
>writing to the screen as the message appears when the host call has finished !
>Can anyone HELP ?
Try:
MESSAGE('Running Report - Please Wait ...');
SYNCHRONIZE;
This force the message to show up.
Hope this help
Kenneth Ho
Programmer
Hospitality Data Resources Ltd., H.K.
>--
>Robbie Hancock
>Database Development Engineer
>Motorola ECID,
>16 Euro Way, Tel No +44 793 545368
>Blagrove, Swindon, Fax No +44 793 541228
>England, SN5 8YQ. E-mail hancockr_at_zeus.swindon.rtsg.mot.com
>"Rude alert! Rude alert! An electrical fire has knocked out my voice
>recognition unicycle! Many Wurlitzers are missing from my database! Abandon
>shop! This is not a daffodil! Repeat: This is not a daffodil!" Holly
Received on Fri Sep 16 1994 - 15:34:36 CEST