Re: [SQL] Update and trigger

am Wed, dem 11.06.2008, um 0:54:55 -0700 mailte Medi Montaseri folgendes: > Thanks...but a difference seems to be that the rule is not specific to update > on a particular col but any col of a row getting updated... > > Thanks Okay, but i havn't an idea. A statement level trigger can't see the

Re: [SQL] Update and trigger

Thanks...but a difference seems to be that the rule is not specific to update on a particular col but any col of a row getting updated... Thanks On Tue, Jun 10, 2008 at 10:21 PM, A. Kretschmer < [EMAIL PROTECTED]> wrote: > am Tue, dem 10.06.2008, um 18:45:51 -0700 mailte Medi Montaseri folgende

Re: [SQL] Update and trigger

Medi Montaseri wrote: Hi, I need to increament a counter such as myTable.Counter of type integer everytime myTable.status a boolean column is updated. Can you help me complete this... create trigger counter_trigger after update on myTable.counter execute procedure 'BEGIN statement; statement

Re: [SQL] Update and trigger

am Tue, dem 10.06.2008, um 18:45:51 -0700 mailte Medi Montaseri folgendes: > Hi, > > I need to increament a counter such as myTable.Counter of type integer > everytime myTable.status a boolean column is updated. Can you help me complete > this... > > create trigger counter_trigger after update o

[SQL] Update and trigger

Hi, I need to increament a counter such as myTable.Counter of type integer everytime myTable.status a boolean column is updated. Can you help me complete this... create trigger counter_trigger after update on myTable.counter execute procedure 'BEGIN statement; statement; statement END' Q1- how d