Can we track how many times the Application is reloaded in a day?

[OmarBenSalem]

Hi guys ( stalwar1) ; I wanted to know is there a way to track how many times an application is reloaded in a single day?

In fact, what I'm doing is creating an application to finally store a table into a csv file like follow:

FileName-AsOfDate 2018-02-08

Normally, each day, we create one file; but if the users demand to reload the application a second and a thrid time;

I want to create 2 new files as follow:

FileName-AsOfDate 2018-02-08 V2 (V2=> 2 nd reload of the day)

FileName-AsOfDate 2018-02-08 V3 => 3 rd reload of the day)

is there a way to achieve this?

[Anonymous]

I would guess that somewhere else in your script you are doing a set ErrorMode=0, but somehow for the Load that fails it actually has not been set.

[OmarBenSalem]

I did a let ErroMode=0 in the begining of the script and revert it back to 1 only in the last line of the whole script..

Strange...

[sunny_talwar · Accepted solution]

May be this

LET vDayStart = Today();

If '$(vDayStart)' = If(Len(Trim('$(vDayEnd)')) = 0, 0, '$(vDayEnd)') then

LET vCounter = $(vCounter) + 1;

ELSE

LET vCounter = 1;

ENDIF;

Table:

LOAD * INLINE [

    Dim

    A

];

LET vSaveFile = Date('$(vDayStart)', 'YYYY-MM-DD')&'V'&$(vCounter);

STORE Table into 'FileName-AsOfDate $(vSaveFile).qvd' (qvd);

LET vDayEnd = Today();

[OmarBenSalem]

Brilliant Sunny !!