Re: Form 5.0 Triggers

Hi,
You can try using KEY-NEXTVAL and WHEN-MOUSE-LEAVE at the level of your last field.
Regards,

Mabel

Frank W Phillips JR wrote in message +ADw-34F6DC30.BEAAE34E+AEA-vpha.ufl.edu+AD4-...
+AD4-Based on a user request I am attempting to write a trigger that will
+AD4-commit a form record to the database after the last field is completed.
+AD4-The problem, I can not find a trigger that will allow this.
+AD4-Do+AF8-key(commit+AF8-form) is a restricted procedure. When-Validate-Item and
+AD4-Post-Text-Item triggers only allow unrestricted procedures.
+AD4-The request is to have an alert after the last field is entered that
+AD4-asks the user to save, edit, or remove the record. Also, this is an
+AD4-accounting app and if the record is not committed to the DB the next
+AD4-time I pull the balance from the DB it will not reflect the uncommitted
+AD4-record that is still pending in the block.
+AD4-They also wish to have the save option display a new blank record (i.e.
+AD4-Next+AF8-Record+ADs-) but this too is a restricted procedure.
+AD4-I have not been using Forms for long, so any help would be great. Thanks
Received on Fri Feb 27 1998 - 00:00:00 CET