Re: help me pls

> i really need some help on this,
>
> i'm trying to fire a trigger after/before(this doesn't matter) i insert a
> record into the database.
> The problem is that, during the time of running the trigger, i have to add
> some data to the inserting record; like.. the time of insert, something like
> that.
> i know that using a temp table, and run the trigger thru the insert of temp
> table will be easier, however, due to some restriction, i can't do that, can
> anybody tell me a better way so that i can edit the data while i'm inserting
> it to the table?
> pls help me out!

I'll go with Sybrand that your question is very hard to understand and I must presume that even though you are at Ohio State University English may not be your first language.

In any case what you appear to be trying to do can not be done with a trigger. And I generally recommend triggers as the last resort for anything in the database for a number of reasons. See if you can accomplish what you are trying to do by passing the values to a stored procedure and having it do the insert and the actions you were planning to do with the trigger.

Daniel A. Morgan Received on Wed Mar 07 2001 - 01:53:35 CST