Re: Forms 4.5 problem.

The answer is to not do this on the form at all.

This should be a database level trigger. That way the solution is bomb proof and you have no way that anyone can get data into your table without it being logged.

Also, an application level solution will have to implemented in every Form that touches the table.

Do it in the table, its the right thing to do.

Paul Dorsey
Dulcian, Inc.

Richu Wu <c559133_at_sp2n09.missouri.edu> wrote in article <60uc5j$103m$1_at_news.missouri.edu>...
> 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 Fri Oct 03 1997 - 00:00:00 CEST