Kurt wrote:
> I'm real rusty with triggers..and I need one fairly quickly, so I
> would really appreaciate a bit of help.
>
>
> All I need to do:
>
> Upon insert or update of a row in a table, I need to check the value
> of one of the columns, and if it equals a certain value, then update
> one of the other columns and 'force' it to a certain value regardless
> of it's value in the insert the statement just issued. (the statement
> will provide a value for that column, but I need to make sure it gets
> forced to a particular value)
>
> This is a temporary fix for an application bug.
>
> Hope that makes sense,
>
> Thanks!
I think that you'll get a mutating table error if you do what I think
you're saying you want to do. There are some ugnly, not-so-convenient
workarounds, of course.
Received on Mon Jan 13 2003 - 11:43:17 CST
