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

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

Have you try to use the WHEN-VALIDATE-ITEM trigger ? It fires when you modify an item. Thus you can detect with a test if it's the first modification of this record. You can by example initialize a boolean variable with the WHEN-NEW-RECORD-INSTANCE trigger and update it with the WHEN-VALIDATE-ITEM trigger. If you want to try this, I suggest you to create a function or a procedure you call in the trigger. You can thus define the WHEN-VALIDATE-ITEM at the block level with a call to this sub-program and insert a call of this sub-program in each WHEN-VALIDATE-ITEM defined at the Item level. Received on Tue Dec 10 1996 - 00:00:00 CET