Creating Triggers From VB using ADO

From: Peta Griffith <peta_at_dataspeed.com.au>
Date: Thu, 21 Feb 2002 14:47:28 +1100
Message-ID: <93_c8.9465$wG3.72547_at_newsfeeds.bigpond.com>

i need to create triggers from a vb application but the ADO library will not accept the syntax for the trigger

this is the syntax that works in plsql or toad

CREATE OR REPLACE TRIGGER SCHEMA.TRIGGERNAME BEFORE INSERT ON SCHEMA.TBLNAME FOR EACH ROW BEGIN SELECT SCHEMA.SEQUENCENAME.nextval INTO :new.FIELDNAME FROM dual; END;

the tables,foreign keys, indexes,sequences all pass through ok the only way i can get the ADO dll to accept this stament is to remove the colon and both semi colons this renders the trigger invalid

Any help would be appreciated

Paul Grimaldi Received on Thu Feb 21 2002 - 04:47:28 CET