Trigger Help

From: Mark Young <mark_a_young_at_worldnet.att.net>
Date: Thu, 22 Jul 1999 15:35:43 -0400
Message-ID: <7n7r36$os2$1@bgtnsc01.worldnet.att.net>

I would like to return the value of a field back to 0 once the value reaches 1000 using a trigger

I have the following:

    if (:new.senumber=1000) then

        begin
            update mytable set senumber=0 where mycondition=mycondition
        end;

    end if;

The trigger will be executed on an update of the senumber column.

Any help would be greatly appreciated.

mark_a_young_at_worldnet.att.net Received on Thu Jul 22 1999 - 14:35:43 CDT