topic Re: What is the function to write a message to the script execution dialog? in QlikView

What is the function to write a message to the script execution dialog?

martynlloyd — Tue, 15 Jul 2014 15:02:29 GMT

During the script execution process, I wish to write some comments to the log to help me track the reload process. Debug is not available as the process is running on a secured server.

Re: What is the function to write a message to the script execution dialog?

jerem1234 — Tue, 15 Jul 2014 15:05:49 GMT

I think Trace is what you are looking for, from Help:

Trace

The trace statement writes a string to the Script Execution Progress window and to the script log file, when used.

It is very useful for debugging purposes. Using $-expansions of variables that are calculated prior to the Trace statement, you can customize the message.

The syntax is:

trace string

Examples:

trace Main table loaded;

Let MyMessage = NoOfRows('MainTable') & ' rows in Main Table';

trace $(MyMessage);

Hope this helps!

Re: What is the function to write a message to the script execution dialog?

datanibbler — Tue, 15 Jul 2014 15:13:02 GMT

Hi Jeremiah,

great!

I knew about the TRACE statement elsewhere - but I would never have thought of using it in this context.

That is the sort of thing I would propose for putting into a WIKI for every newcomer to consult - if I had known this about a year ago when I started doing this, it would have helped me a great deal.

Best regards,

DataNibbler

Re: What is the function to write a message to the script execution dialog?

martynlloyd — Tue, 15 Jul 2014 15:30:53 GMT

Thats great Jeremiah, many thanks!

Is there a way to do this in a subroutine?

FOR Each Dir in dirlist (Root&'\*' )
TRACE $(Dir);
call DoDir (Dir)
NEXT Dir

Regards,

ML.