Unanswered: form trigger needed to display db values
In Designer6i I have created a form that has an action item (button)
that when pressed calls the CANCEL procedure. The CANCEL procedure
changes the value of a database column (STATUS_CODE) from 'AUTHORIZED' to 'CANCELED'. What trigger can I use at the block level that will update the block on the form and display the new db STATUS_CODE value on the form?
I tried using POST-UPDATE with this code:
where rowid = :blk_items.rowid;
It did not requery the database and display the new values.
This is the code for my procedure:
CREATE OR REPLACE PROCEDURE cancel
(p_id IN planning_groups.id%type)
items.status_code = 'CANCELED'
items.pg_id = p_id
AND items.status_code = 'AUTHORIZED';
('Items with AUTHORIZED status were changed to CANCELLED.');
WHEN NO_DATA_FOUND THEN
(-20201, 'No data was found.');