Re: Forms4.5 Trigger when entering a character in a new record

Volker,

There are no triggers that fire while you enter data in a field. Triggers fire going in and coming out of an item. What does happen is that the system.record_status changes to CHANGED or INSERT depending if you are updating or inserting (the other two stati it can be are NEW and QUERY). So, you can use a POST-TEXT-ITEM trigger to check the system.record_status to see if it changed. If so, then do whatever you want to do, if not then keep going. This trigger fires for any navigation out of a text item, whether it be by keyboard or mouse.

Hope this helps.

Mark Freudenberg

VHAUSWUR_at_Materna.DE (Volker Hauswurz) wrote:

>We have some master-details and we have to lock the master when we update the
>master, but also when inserting a detail for a master.
 

>I would like to know if there is a trigger which fires when you enter a new
>character in a field of a new record.
>Create-record and When-New-Record-Instance already fire when you navigate to a
>new record in the detail block.
>If you update a queried record the ON_LOCK trigger fires. So we search for a
>way to handle the situation when you enter the first character in a new record.
>Does anyone know a solution?
 

>Thanks
>Volker
Received on Mon Dec 09 1996 - 00:00:00 CET