Re: Check on column when record is updated

Hee hee, thought so my luck was out.

This is not a 'Date' column.
It's a "Data Entry Employee Id".

That means for the employee who is logged on to the application, his/her ID(number) will be captured in this field.

Thanks.

On Wed, 22 Jan 2003 10:54:00 +0300, "Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote:

>Your logic is a bit flawed here. First of all, :OLD represents the current contents
>of the row being updated and it can't be altered, so
>> The above works fine except that if the same employee did the data-entry
>> for both the old and new records, we have a problem. It's gonna give out
>> an error for a genuine update.
>is not an issue as this is impossible. Secondly, you do not need to force the
>*application* to update this column - you can always do it in the trigger
>itself - just assign SYSDATE to this column, disregarding any input from the
>application and you will always have correct row modification time regardless
>if application provided it or not.
>
>"You should better learn your kanji before you may kumite."

To e-mail me, remove "rm_" Received on Wed Jan 22 2003 - 02:57:00 CST