Re: trigger question
From: Douglas A. Cummins <dacummins_at_delphi.com>
Date: 1995/04/30
Message-ID: <x01f6eV.dacummins_at_delphi.com>#1/1
Date: 1995/04/30
Message-ID: <x01f6eV.dacummins_at_delphi.com>#1/1
a common approach is to add four columns to the tables to be monitored - created by / created date / last updated by / last updated date. research triggers a little more - you should find the solution to be easy. remember to use 'before each row' triggers! you must use 'before' because you are modifying data, and you must use 'each row' in case any statement modifies multiple rows.
good luck,
douglas
delphi consulting services, inc.
800.578.3075
:->
Received on Sun Apr 30 1995 - 00:00:00 CEST