Re: Forms 4.5 problem.

You need to handle the creation items in a pre-insert trigger and the modification items in a pre-update trigger.

John

>I have a simple form which has to have four hidden fields beside other
>fields:
>"created by User", "Create Date", "Modified by user"and "Modify Date".
>When you insert into the table, form will get the user info from the
>system
>and put it into the "created by user" field.sysdate to the "create date".
>when update, it will change the "modified by user" field.
>My question is what would be the best trigger to do this? Pre-insert
>trigger?
>
>Thank you
>
>Rich
>
>
>
>
>
>
>
Received on Wed Oct 01 1997 - 00:00:00 CEST