erickwidya
June 22nd, 2005, 05:42 AM
currently i'm using TRIGGER for INSERT, DELETE, UPDATE which Insert new record to tblLogs
the table structure = UserName | DateTime | ActionTaken (I, D, U) | TableName
everything works fine until i realize that i missed important thing which is the "ColumnName" that user changed coz in here User seem easily forgotten what they have done, that's why i planning using the tblLogs
so the question would be How (if not involved complicated method)? or any other better method?
i open for any idea
thanks
the table structure = UserName | DateTime | ActionTaken (I, D, U) | TableName
everything works fine until i realize that i missed important thing which is the "ColumnName" that user changed coz in here User seem easily forgotten what they have done, that's why i planning using the tblLogs
so the question would be How (if not involved complicated method)? or any other better method?
i open for any idea
thanks