Re: Newbie needs help with Trigger

From: Shatalov Vadim <skiv_at_admkom.tlt.ru>
Date: Mon, 30 Nov 1998 09:54:27 +0400
Message-ID: <adct37.ing.ln@news.admcity.tlt.ru>

Jeff Howey wrote in message ...
>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;

Use Sequences

2 Beer is not 2 Bear !

---

Shatalov Vadim,
Oracle DBA ,Togliatti, Administration Komsomlsk region Phones : +7(8469)245417
mail : skiv_at_admkom.tlt.ru

begin 666 Vadim Petrovich Shatalov.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..E-H871A;&]V.U9A9&EM.U!E M=')O=FEC: T*1DXZ5F%D:6T_at_4&5T<F]V:6-H(%-H871A;&]V#0I414P[5T]2 M2SM63TE#13HW+3_at_T-CDM,C0U-#$W#0I!1%([2$]-13H[.SL[.SM2=7-S:6$- M"DQ!0D5,.TA/344Z4G5S<VEA#0I%34%)3#M04D5&.TE.5$523D54.G-K:79 M861M:V]M+G1L="YR=0T*14U!24P[24Y415).150Z=&]P+6UO9&5L0&%T=&%C G:RYR=0T*4D56.C$Y.3_at_Q,3,P5# U-30R-UH-"D5.1#I60T%21 T* `
end Received on Sun Nov 29 1998 - 23:54:27 CST