Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Newbie needs help with Trigger

Newbie needs help with Trigger

From: Jeff Howey <jeffery.howey_at_mci.com>
Date: Tue, 17 Nov 1998 15:02:46 GMT
Message-ID: <qeg42.1$Gy5.46@news.cwix.com>


Hi! I believe that I have a valid Trigger ready to go, the problem I have now is that when my C++ program tries to insert, we don't know how to code the insert statement... can anyone help with a short example? I've included my trigger code...

All I want to do is increment a "count" field and then insert the other few columns of data from my program so I can enable it. Thanks!



CREATE OR REPLACE TRIGGER "TEST"."INCREMENT" BEFORE INSERT ON "TEST"."TABLE" REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW begin   :NEW=(:OLD+1)
end; Received on Tue Nov 17 1998 - 09:02:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US