Need trigger for form.

From: M Hamilton <mhamilton_at_usgs.gov>
Date: 20 Nov 2003 13:48:48 -0800
Message-ID: <7ce65461.0311201348.18a070e0_at_posting.google.com>

[Quoted] 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 value in the field?

I tried using POST-UPDATE with this code: BEGIN
    select status_code
    into :it_gdaps_mc.status_code
    from items_gdaps
    where rowid = :it_gdaps_mc.rowid;
END; [Quoted] It did not requery the database and display the new values.

Thanks in advance,
MH Received on Thu Nov 20 2003 - 22:48:48 CET