Re: Forms 5.0 and database triggers
From: wozi <wozi_at_dhc.net>
Date: Sat, 29 May 1999 16:44:09 -0700
Message-ID: <67313DEA019C0C66.D3F0C9E7C7F2DC0B.BE3BF5E8ED1BDCC9_at_library-proxy.airnews.net>
Date: Sat, 29 May 1999 16:44:09 -0700
Message-ID: <67313DEA019C0C66.D3F0C9E7C7F2DC0B.BE3BF5E8ED1BDCC9_at_library-proxy.airnews.net>
Louis Spies wrote in message:
>I have an insert trigger on a table that changes the value of one of the
>fields that are inserted into a table.
>
>When inserting a record from within Forms, how can I get Forms to
>display the new value after the insert trigger has fired?
I am going to assume you are using a custom pushbutton to implement the
insert. Then, one possible solution would be to SELECT ... INTO
:block_name.item_name, :block_name.item_name etc.
FROM ...
WHERE ...
hope that gets you started wozi_at_dhc.net
Received on Sun May 30 1999 - 01:44:09 CEST