Skip to main content

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.

Syntax:  

Trace string

Example 1:  

The following statement can be used right after the Load statement that loads the 'Main' table.

Trace Main table loaded;

This will display the text ‘Main table loaded’ in the script execution dialog and in the log file.

Example 2:  

The following statements can be used right after the Load statement that loads the 'Main' table.

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

Trace $(MyMessage);

This will display a text showing the number of rows in the script execution dialog and in the log file, for example, ‘265,391 rows in Main table’ .