Re: Form 5.0 Triggers

the best bet 2 call restricted procedures is to create a time and using them in the when-timer-expired trigger, but if u get a gpf, timer's wont fire(if oracle has not fixed this).

--Arvind

Frank W Phillips JR wrote:

> Based on a user request I am attempting to write a trigger that will
> commit a form record to the database after the last field is completed.
> The problem, I can not find a trigger that will allow this.
> Do_key(‘commit_form’) is a restricted procedure. When-Validate-Item and
> Post-Text-Item triggers only allow unrestricted procedures.
>
> The request is to have an alert after the last field is entered that
> asks the user to save, edit, or remove the record. Also, this is an
> accounting app and if the record is not committed to the DB the next
> time I pull the balance from the DB it will not reflect the uncommitted
> record that is still pending in the block.
>
> They also wish to have the save option display a new blank record (i.e.
> Next_Record;) but this too is a restricted procedure.
>
> I have not been using Forms for long, so any help would be great. Thanks

--
Balaraman Arvind
151 Andrew Ave, Apt 215
Naugatuck, CT 06770

ph   -  (203)-723-1190(R)
     -  (203)-459-7502(O)

mail -  dnivra_at_ix.netcom.com (R)
        abalaram_at_oxhp.com    (O)