In order to enable log triggers on the table, you'll have to go to the table Features and select the desired logging type (all changes or operations only):
If "Log changes" is selected, you should decide which table fields will be logged (or not):
In this case, all fields selected to be logged will have their values written on the database table logXXXall (where XXX is your system acronym) per operation. You'll have more information when the change occurred, but will need more space and processing each time an operation is done in that table.
Otherwise, if "Log operations only" is selected on table properties then only the primary key field of the record and the type of operation executed will be logged.
Hope this helps.
About This Community
|Asked: 10/10/19, 9:39 AM|
|Seen: 244 times|
|Last updated: 4/22/20, 9:39 AM|