Re: Trigger on specific column

How do you make the column variable?
If I have 10 columns, do I need 10 update triggers (1 for each column)? Or can I do it in one trigger knowing which column the update is happening on?

Thanks again.

In article <3a1a1dd8_at_news.gwi-ag.com>,
  "Markus Roeder" <markus.roeder_at_gwi-ag.com> wrote:
> If a triggering statement specifies UPDATE, an optional list of
 columns can
> be included in the triggering statement. If you include a column list, the
> trigger is fired on an UPDATE statement only when one of the specified
> columns is updated. If you omit a column list, the trigger is fired
 when any
> column of the associated table is updated. A column list cannot be
 specified
> for INSERT or DELETE triggering statements.
>
> The previous example of the trigger might have included a column list
 in the
> triggering statement, as in
>
> . . . BEFORE UPDATE OF ename ON emp . . .
>
> Regards,
>
> Markus
>
> <bshah_at_sportsmail.com> schrieb im Newsbeitrag
> news:8vc3u1$es$1_at_nnrp1.deja.com...
> > Hi,
> >
> > How do you create a trigger for a specific column (or set of columns)?
> > For example, I would like to take one action for an update to col x,
> > and another action for an update to col y.
> >
> > Thanks in advance.
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 21 2000 - 12:14:14 CST