Forms 4.5 problem.
From: Richu Wu <c559133_at_sp2n09.missouri.edu>
Date: 1997/10/01
Message-ID: <60uc5j$103m$1_at_news.missouri.edu>#1/1
Date: 1997/10/01
Message-ID: <60uc5j$103m$1_at_news.missouri.edu>#1/1
[Quoted] [Quoted] 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