• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Log

 
Giuseppa Cefalu
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I would like to be able to keep a log of all the modifications that are done in the database. For example, some one makes a change to a value from 4 to 5. I would like to write a table that reads the original value, saves it to a table and reads the value replaced with and saves it to the same table together with the time and date and which the change was done. Are there any other items I should be aware off that need to be kept in a log table? My program is an interface that allows the user to insert, update and delete records from the database. Is there any reading that you would recommend?

Thank you
 
Giuseppa Cefalu
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I wonder if I can create part of the log by saving the output of the table below to a database table

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic