Re: Can you call Oracle triggers from VB?
From: Paulo Eufemia <eufemia_at_memosis.pt>
Date: 2000/07/10
Message-ID: <8kc517$pou$1_at_onix.memosis.pt>#1/1
Date: 2000/07/10
Message-ID: <8kc517$pou$1_at_onix.memosis.pt>#1/1
The most transparent way is to create a DATABASE trigger that fires automatically every time you commit a new record in the database ! That trigger increment a oracle sequence, previously created by you, and put the sequence value in the table's column before execute the commit. The VB don't have to do nothing to fire the trigger because it is a database trigger. Received on Mon Jul 10 2000 - 00:00:00 CEST