Use database query and object action logging in the System Debugger to look for errors and optimize scripts during development. The processing time and the command that was run are logged.
Table 142: Functions for logging database queries and object actions
|
|
Starts recording. |
|
|
Stops recording. |
|
|
Copies logged data to the clipboard. |
|
|
Save logged data in a file. |
|
|
Deletes the logged data. |
The System Debugger gives you the opportunity to test scripts, templates, formatting rules, methods, and table scripts. Visual Studio debug and edit options are available to you.
Detailed information about this topic
To test a script
-
In the System Debugger, select the desired script in Scripts view.
-
Enter value for the script parameters as required.
-
Check the options for running the script.
-
Run in debug mode: Jumps into the source code. This allows you to use all Visual Studio debugging options.
-
Define base data: The Base and Value variables of the script base class can be pre-allocated as input parameters to be used in the script.
Example:
Base is initialized with a DB object key in order to use base.GetValue("column name").String.
-
Transaction with rollback: Use this option to specify whether the script is run within a transaction with subsequent rollback or whether the script is run immediately against the database.
-
Select Start.
The script starts running. After the script has run, the result and the processing time of the script is displayed.
TIP: To find scripts more easily, you can use the following functions in the Scripts view.
-
In the Find script field, enter the string to filter on.
-
Modified scripts are marked with a * in the System Debugger.
-
To find all modified scripts, click 
and apply the Changed scripts menu item.
Related topics
To test a template
-
Select the column with template in System Debugger from Templates.
-
Select the column with the template you want to test under Notifier column.
-
Select the object in Database object to which to apply the template.
-
Check the Transaction with roll back option for running the templates.
Use this option to specify whether the template is run within a transaction with subsequent rollback or whether the template is run immediately against the database.
-
Select one of the following actions to test the template.
|
Save |
The object is saved. |
|
Discard |
The changes made to the object are discarded. |
|
Load |
The object is reloaded. |
|
New |
A new object is created. |
|
Run |
The template is run again. |
To test a formatting script
-
In the System Debugger, select the column with the formatting script in Formats.
-
Select the object in Database object to which to apply the formatting script.
Related topics
