How to save / record the date and time when the app is updated

[Anonymous]

Hello,

Does anyone know how to leave the date and time recorded, for example in a table, each time the data is loaded?

I use the ReloadTime () command to display the date and time, but I need to keep track of all the times I update the application.

First of all, Thanks.

[vishsaggi]

I am not sure if there is any better way of doing this but may be one solution is below:

Please change the path in the below variable for storing qvd.

SET vQVDPath = 'C:\Miguel\QVD\';

LET vQVDExist = ISNULL(QvdCreateTime('$(vQVDPath)Reload.qvd'));

IF $(vQVDExist) = -1 then

Reload:

LOAD ReloadTime() AS ReloadDt

AutoGenerate 1;

Store Reload INTO $(vQVDPath)Reload.qvd(qvd);

Drop Table Reload;

ELSE

FinalReload:

LOAD *

From $(vQVDPath)Reload.qvd(qvd);

Concatenate

LOAD ReloadTime() AS ReloadDt

AutoGenerate 1;

Store FinalReload INTO $(vQVDPath)Reload.qvd(qvd);

Drop Table FinalReload;

ENDIF;

Final:

LOAD *

From $(vQVDPath)Reload.qvd(qvd);