Procedure Test

Use the Procedure Test to test the procedures for a table. This allows you to debug your procedure definitions before deploying your model. For a basic introduction, see the procedure example in the tutorial.

From the Procedure Test dialog box you can access the Debug Procedure dialog box. More information on debugging procedures appears below.

Testing a Procedure

To test a table's procedure(s), you must either be connected to the host and have access to the application the model is based on, or you must load the model in the Host Emulator and connect to it.

To test a procedure, follow these steps:

Load the host application model containing the procedure to test into the Design Tool.
Connect to the host.
Select Procedure Test from the Debug menu to display the Procedure Test dialog box.
Click the down arrow next to Table and select the table containing the procedure you want to test.
Click the down arrow next to Procedure and select the procedure you want to test.
All filter and data parameters for the selected procedure appear in the Procedure filters box. If the filter is defined as required, a check mark appears in the box to the left of the filter.
In the Value column, enter data for the parameter.
If a parameter is required, you must enter a value for that parameter.
Click Execute.

The Design Tool will test the procedure. If this is a SELECT procedure, the Design Tool will display the output in the Procedure outputs dialog box. The record count is displayed at the bottom of the dialog box.

If the Terminal window is visible, you will see the Design Tool navigate to the appropriate host screen while it tests the procedure.

Procedure options

You can limit the number of records to be returned for the procedure test. Type in a number for Limit results to <x> records. The total record count is displayed with the procedure results.
After executing the procedure, click Copy to copy the procedure output to the Clipboard.
If an event handler that includes an Execute Procedure call is attached, a lightning bolt () is displayed in front of the procedure name. When you click Execute, the associated event handler is invoked as part of the procedure test. The Execute Default button is available so that you can test the procedure without testing the event handler at the same time. Click Execute Default to test the procedure as displayed in the Procedure Editor, without testing the associated event handler.

Debugging a Procedure

If you experience problems with a procedure used to satisfy an SQL query or you want to fully investigate the behavior of a procedure, you can debug it in the Debug Procedure dialog box.

Click the down arrow next to Table and select the table containing the procedure you want to test.
Click the down arrow next to Procedure and select the procedure you want to test.
All filters for the selected procedure appear in the Procedure filters box. If the filter is defined as required, a check mark appears in the box to the left of the filter.
In the Value column, enter data to test against the procedure.
All filters for the selected procedure appear in the Procedure filters box. If the filter is defined as required, a check mark appears in the box to the left of the filter.
Click Debug to open the Debug Procedure dialog box with the procedure displayed.