Previous Next

See Also

USoft BenchMark has a Tracer that allows you to visually trace SQL statements, manipulations, and method calls that are executed while you are interacting with a USoft application. The Tracer window displays information about:

· SQL statements that are executed on the database, such as performing a query, inserting a record, locking a record, or executing a constraint.


· USoft methods that are handled locally, such as navigating to another record, setting a window in Define Query mode, or performing a query. These methods can cause SQL statements to be executed on the database.

The Tracer window shows you the reason for the execution, the SQL code of the statement, and the constraint or relationship involved. If the SQL statement involves data manipulations, the Tracer window shows you the old values and the new values that result from the manipulation.