Topic: LOGGING FEATURE
Good day everyone!
I'd like to ask if MVD has a logging feature that records all the transactions in the system. Like who or which user that made the changes in the database from login to CRUD transactions. Thank you.
My Visual Database → General → LOGGING FEATURE
Good day everyone!
I'd like to ask if MVD has a logging feature that records all the transactions in the system. Like who or which user that made the changes in the database from login to CRUD transactions. Thank you.
Good day everyone!
I'd like to ask if MVD has a logging feature that records all the transactions in the system. Like who or which user that made the changes in the database from login to CRUD transactions. Thank you.
I think there is none, you need to create your own logic for this.
I do it with triggers using a database admin tool, there is no tool in MVD to create triggers.
https://myvisualdatabase.com/forum/view … hp?id=3642
While this is an easy way to create triggers, it is also a weird one, since they are rebuilt every time the form is shown and the code is exposed in the script file, hence why I prefer to use a database admin tool to create them.
I guess it's also possible, instead of using triggers, to write a script to also log changes to whatever fields you need to audit (not all fields are critical).
Please see attached as a simple example.
Derek.
Nice one Derek, it is quite a bit of code though
My Visual Database → General → LOGGING FEATURE
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi