From: freud@gate.net (Mark Freudenberg) Subject: Re: Forms4.5 Trigger when entering a character in a new record Date: 1996/12/09 Message-ID: <58hjnp$io8@news.gate.net>#1/1 references: organization: CyberGate, Inc. newsgroups: comp.databases.oracle.tools 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@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