Re: [GENERAL] A generic trigger to log chanes on database tables

2006-11-28 Thread George Weaver
- Original Message - From: "Charles Ambrose" <[EMAIL PROTECTED]> Is there a way that I could create a trigger that logs the changes (updates, deletes) of a table? I mean, I want to put in a table the changes to any table in a database and also put in the table the column that was m

Re: [GENERAL] A generic trigger to log chanes on database tables

2006-11-27 Thread Jim Nasby
On Nov 23, 2006, at 10:32 AM, Charles Ambrose wrote: Is there a way that I could create a trigger that logs the changes (updates, deletes) of a table? I mean, I want to put in a table the changes to any table in a database and also put in the table the column that was modified and the corres

Re: [GENERAL] A generic trigger to log chanes on database tables

2006-11-23 Thread A. Kretschmer
am Fri, dem 24.11.2006, um 0:32:30 +0800 mailte Charles Ambrose folgendes: > Hi! > > Is there a way that I could create a trigger that logs the changes (updates, > deletes) of a table? I mean, I want to put in a table the changes to any table > in a database and also put in the table the column

[GENERAL] A generic trigger to log chanes on database tables

2006-11-23 Thread Charles Ambrose
Hi! Is there a way that I could create a trigger that logs the changes (updates, deletes) of a table? I mean, I want to put in a table the changes to any table in a database and also put in the table the column that was modified and the corresponding value. My audit table looks like this: Table