Trigger error

From: Peta Griffith <peta_at_dataspeed.com.au>
Date: Wed, 7 Mar 2001 16:30:31 +1100
Message-ID: <lwjp6.9769$v5.39750@newsfeeds.bigpond.com>

Trigger Error
using the oracle oledb provider and ado with visual basic when creating a trigger

this statement will return then error 'No value given for one or more required parameters'

con.execute "CREATE OR REPLACE TRIGGER SYLOGIN.TRI_SEQ_ERRORLOG BEFORE INSERT ON SYLOGIN.ERRORLOG FOR EACH ROW BEGIN SELECT SYLOGIN.SEQ_ERRORLOG.nextval INTO : new.ID FROM dual; END;"

this statement will create trigger with no error but the trigger will be invalid as there is no colon in the statement

con.execute "CREATE OR REPLACE TRIGGER SYLOGIN.TRI_SEQ_ERRORLOG BEFORE INSERT ON SYLOGIN.ERRORLOG FOR EACH ROW BEGIN SELECT SYLOGIN.SEQ_ERRORLOG.nextval INTO new.ID FROM dual; END;"

help Received on Tue Mar 06 2001 - 23:30:31 CST