# 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’ .