How to show DB Trig Message in Forms3.0
From: Marty Adolf <madolf_at_teleport.com>
Date: 1996/09/11
Message-ID: <Pine.SUN.3.92.960911165428.26355B-100000_at_kelly.teleport.com>#1/1
Date: 1996/09/11
Message-ID: <Pine.SUN.3.92.960911165428.26355B-100000_at_kelly.teleport.com>#1/1
Any help to this is welcome.
I have created a database trigger to prohibit a particular update circumstance. I want to display a meaningful message in Forms 3.0, but the only way I have discovered to get a message is to capture the error code in the On-Update trigger and writing a message in the Exception clause. Which would be fine except I have to write the update statement in the trigger as well and this has seriously degraded performance.
Is this the only way to get a meaningful message to appear in Forms 3.0 in response to user-defined database trigger failure? Am I doing something wrong?
Thanks! Received on Wed Sep 11 1996 - 00:00:00 CEST