My Visual Database — LOGGING FEATURE

Re: LOGGING FEATURE

null@example.com (tcoton) — Tue, 27 Feb 2024 15:41:09 +0000

Nice one Derek, it is quite a bit of code though

Re: LOGGING FEATURE

null@example.com (derek) — Tue, 27 Feb 2024 15:11:14 +0000

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.

Re: LOGGING FEATURE

null@example.com (tcoton) — Tue, 27 Feb 2024 15:04:11 +0000

k245 wrote:

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.

Re: LOGGING FEATURE

null@example.com (k245) — Tue, 27 Feb 2024 05:56:05 +0000

https://myvisualdatabase.com/forum/view … hp?id=3642

Re: LOGGING FEATURE

null@example.com (tcoton) — Sun, 25 Feb 2024 21:48:11 +0000

I do it with triggers using a database admin tool, there is no tool in MVD to create triggers.

Re: LOGGING FEATURE

null@example.com (brian.zaballa) — Fri, 23 Feb 2024 12:42:24 +0000

jayvallejera wrote:

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.

LOGGING FEATURE

null@example.com (jayvallejera) — Fri, 20 Oct 2023 08:56:19 +0000

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.