[WB 24] Log file

Good afternoon

Does anybody maybe have advice on how to implement a log file of changes to a HF SQL table. I know there is an feature to create automatic logs but in a multi user system I would like to know which user changed the record and what changes were made.

Just to give one example. If a user changes the banking details for a supplier that must be logged with the before and after details, when it was done and by whom. There is however a multitude of other information also to be logged.

Thanks in advance for any assistance.


Ericus Steyn

We have implmented this kind of LOG using triggers.BEFORE and AFTER
We store information about the changes in the data and a lot of information regarding the WB session.

[doc.windev.com]

Regards

Paulo Oliveira

You can look in fabrice's wxreplication. His replication mechanism is in fact a complete log system storing everything you asked and more, and then being transfered and used on other machines.
He's overwriting the hadd, hmodify and hdelete instructions and doing a whole dance in there.