Tracer Window: Tracer Tab Page

The Tracer tab page consists of a list of executed items, detailed information on the item selected in the list, and navigation buttons.

Tracer Tab Page Example

The Tracer tab page displays information for each action that causes SQL statements or methods to be executed on the server (e.g. performing a query, inserting a record, or executing a constraint). This window displays the reason for execution, the statement itself, any methods involved, and the constraint or relationship involved.

If the SQL statement involves data manipulation (INSERT, UPDATE, DELETE), then the "old" and "new" values that result from the manipulation are also displayed.

When tracing a transaction in which domain constraints are evaluated, the tracer also shows the domain name of the domain constraint for statements that are executed as a result of a domain constraint.

The execution of methods, SQL statements or manipulations can trigger other methods, SQL statements, or manipulations. These relationships are shown in the list. The top item is the current item.

Click an item in the list to view the detail information for that particular item.. The detail field displays additional information on the selected item in the list. This information is different for each item:

·	SQL statement in case of the execution of a SQL statement. For more information, see "Reasons for SQL statements".

·	Method call in case of a method call.

·	Manipulation in the case of a manipulation. The "old" and "new" values that result from the manipulation are displayed. It is also possible to make a distinction between changed columns or all columns by (un)checking the 'Changed columns only' checkbox.

The navigation buttons allow you to choose how to navigate through the execution:

1.	Click the "Step Into" button to single-step through the SQL statements or methods in the application.

2.	Click the "Step Over" button to single-step through the SQL statements or methods in the application. If this command is used and as a result of the step a nested SQL statement or method is executed, the SQL statement or method is executed without tracing the nested SQL or methods.

3.	Click the "Step Out" button to execute the current SQL statement or method, and stop on the SQL statement or method immediately following. Using this command, you can quickly finish executing the current SQL statement or method when you have finished analyzing it.