On Fri, 22 Sep 2006, Dennis Cote wrote:
The table must exist before the triggers can be created. The triggers are associated with the table by naming the table in the trigger's create statement, not by naming the trigger in the table's create statement.
Dennis, I wondered about that after sending the message and leaving the office for a bit. On reflection it makes perfect sense. I'll drop and recreate the table.
HTH
Certainly did! Thanks, Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc.(TM) | Accelerator <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
