audit trail
-
Hi, I want to use audit trail for my application.In my view i shd create one new table with same structure of original table and insert old record of original table into new table at the time of update record.But how to know that there is any updation or not in this record b'cas if any user click on update button then update query will fire either you r updating record or not. Second thing is that i have 40 fields in my table so it is not feasible to me to check for each column of that record for change. Please suggest me way to implement audit trail in my application N!dh! :)
-
Hi, I want to use audit trail for my application.In my view i shd create one new table with same structure of original table and insert old record of original table into new table at the time of update record.But how to know that there is any updation or not in this record b'cas if any user click on update button then update query will fire either you r updating record or not. Second thing is that i have 40 fields in my table so it is not feasible to me to check for each column of that record for change. Please suggest me way to implement audit trail in my application N!dh! :)
Create a trigger which will execute when update happens. Insert the data into audit table from this trigger. :)
Navaneeth How to use google | Ask smart questions
-
Create a trigger which will execute when update happens. Insert the data into audit table from this trigger. :)
Navaneeth How to use google | Ask smart questions