Re: Problem with Form_Trigger_Failure in Key-Commit trigger
From: Dennis Klindrup <dek_at_tpi.dk>
Date: 1998/01/20
Message-ID: <01bd2585$87bb0260$26012a0a_at_dek>#1/1
Date: 1998/01/20
Message-ID: <01bd2585$87bb0260$26012a0a_at_dek>#1/1
Hi Thenard
It could look like you try to navigate out of the block, which forces
Oracle to ask the question. Try to stay in the block. If you absolutely
have to leave the block, you could clear the record/block, or fiddle with
the status (WARNING: DIRTY INDEED, and may cause other problems in special
situations).
By the way: Have you considered what happens if the user does not commit
via the key-commit (i.e. types data in the block and tries to leave without
committing). If this is a potential problem, consider using on-commit
and/or post-forms-commit triggers. The commit-sequence is interrupted
automatically in case of failure in these triggers.
reg.
Dennis Klindrup Received on Tue Jan 20 1998 - 00:00:00 CET