Committing from a Forms 4.0 trigger
Date: 6 Feb 1995 03:03:41 GMT
Message-ID: <3h43id$52d_at_griffin.itc.gu.edu.au>
Hello,
I'm hoping someone can help me out with this annoying problem:
Sample trigger on when-button-pressed in Forms 4.0..
BEGIN IF :status = 'OK' THEN
UPDATE othertable set status = :status where id = :id; COMMIT; end if;
EXCEPTION
WHEN NO_DATA_FOUND THEN
INSERT INTO OTHERTABLE (etc.....);
COMMIT;
END;
If I exclude the COMMIT; lines, the othertable is not updated immediately.
If I include COMMIT; the othertable is updated but a message 'no changes to
commit' appears. This is confusing to form users.
Q. Is there any way to immediately modify an unrelated table from a
trigger within Forms 4, either by a) hiding the annoying message,
or b) committing only the change to the
othertable, not the whole form?
One way is to have a hidden dummy bind variable changing for each button
press, is there anything easier?
Many Thanks for any advice.
Peter Walve
QPRI.
Received on Mon Feb 06 1995 - 04:03:41 CET