My Visual Database — Populate an history table on action "save"

Re: Populate an history table on action "save"

null@example.com (tcoton) — Fri, 16 Jan 2015 12:02:54 +0000

The script is now mature, if somebody is interested, I could write a document and submit it to the Author of MVDB for implementation in the official documentation.

Re: Populate an history table on action "save"

null@example.com (DriveSoft) — Wed, 03 Dec 2014 09:35:01 +0000

// comments
ShowMessage('Hello'); // comments

Re: Populate an history table on action "save"

null@example.com (tcoton) — Wed, 03 Dec 2014 08:05:17 +0000

What is the correct syntax to put comments in the code? I would like to make the script easy to understand as per good practice.

Re: Populate an history table on action "save"

null@example.com (tcoton) — Tue, 02 Dec 2014 12:29:10 +0000

It works great, thanks a lot for fast reply!

Now I will learn how to implement everything into my own db

Re: Populate an history table on action "save"

null@example.com (DriveSoft) — Tue, 02 Dec 2014 12:18:56 +0000

I made example for you:

Re: Populate an history table on action "save"

null@example.com (tcoton) — Tue, 02 Dec 2014 12:06:15 +0000

Ok, great but I am not a developer as for almost all your users, how can I implement that with the employee log database?

Re: Populate an history table on action "save"

null@example.com (DriveSoft) — Mon, 01 Dec 2014 15:56:21 +0000

tcoton wrote:

Do you think it would be possible to capture the Windows user login to log who performed changes in the database?

Yes, you can get user name using function GetUserName

example:

ShowMessage(GetUserName);

Re: Populate an history table on action "save"

null@example.com (tcoton) — Mon, 01 Dec 2014 14:23:17 +0000

Do you think it would be possible to capture the Windows user login to log who performed changes in the database?

Re: Populate an history table on action "save"

null@example.com (DriveSoft) — Thu, 27 Nov 2014 18:20:10 +0000

tcoton wrote:

Wow, it is more complex than I thought.
It works now but when I create a new record, the ID is logged as -1 instead of current ID

Checked, current ID also logged, please, send me screenshot, where you find -1 ?

Re: Populate an history table on action "save"

null@example.com (tcoton) — Thu, 27 Nov 2014 13:21:02 +0000

Wow, it is more complex than I thought.

It works now but when I create a new record, the ID is logged as -1 instead of current ID

Re: Populate an history table on action "save"

null@example.com (DriveSoft) — Mon, 24 Nov 2014 22:27:05 +0000

tcoton
added it to the project, please download again
http://myvisualdatabase.com/forum/misc. … download=1

Re: Populate an history table on action "save"

null@example.com (tcoton) — Mon, 24 Nov 2014 18:19:54 +0000

I spent some time to look how the script works, I am still struggling in logging the last 2 columns (birthdate and ID) when deleting a line. I would prefer to log all the information contained in a row, but I did not understand how to manage it.

An explanation would be more than welcome

Re: Populate an history table on action "save"

null@example.com (DriveSoft) — Mon, 03 Nov 2014 10:15:41 +0000

At the moment there is no documentation about script, because used popular programming language "ObjectPascal", you can read any book about Delphi.

But documentation is planned.

Re: Populate an history table on action "save"

null@example.com (tcoton) — Mon, 03 Nov 2014 09:53:40 +0000

Thanks a lot for super fast reply. Being very busy at the moment, I have no time to try it but I will do as soon as I have some spare time.

I quickly looked into your example and everything is based on scripts. Would it be possible to get any kind of documentation about the script features? (functions, how to use them, etc...) That would be very helpful especially if you want to sell you application to companies.

Re: Populate an history table on action "save"

null@example.com (DriveSoft) — Mon, 20 Oct 2014 22:38:54 +0000

It is possible, but maybe it will be a little difficult.

Please, download example project: