...
You can give a Name to your DB Request element. It is used to construct the result status variable names. If the Name is not empty, the name_STATUS_CODE, name_CHANNEL_STATUS_CODE, and
name_STATUS_MESSAGE variables are created, and can be used in other expressions. See the following table for more details:
...
The DB Request (SQL) element can have a Name. It is used to construct the result status variable names. If this attribute is not empty, the name_STATUS_CODE, name_CHANNEL_STATUS_CODE, and
name_STATUS_MESSAGE variables are created, and can be used in other expressions.
...
The "Properties" window to the right allows to edit several parameters of the Run Panel element manually:
| Anchor | ||||
|---|---|---|---|---|
|
The Data Lookup provides the ability to perform lookups.
After dragging and dropping it to the work area, you can select the required lookup:
The following dialog window opens:
You can either browse the file tree to find the needed lookup, or one can use Quick Search.IWS fills in several fields automatically, and you can fill in the input parameters manually, for example:
The Data Lookup element can have name parameters. A name is used to refer to the Data Lookup element, later, to check the execution results.
If this attribute is not empty, the Name_STATUS, Name_STATUS_MESSAGE, Name_RESULT and Name_LOOKUP_STATUS variables are created and can be used in other expressions.
The below table lists the possible values and descriptions for the name parameters.
Variable | Possible values and descriptions |
|---|---|
Name_LOOKUP_STATUS | 0 – The panel was not executed. For example,the Data Lookup execution condition did not evaluate to TRUE.1 – Success with data.2 – Success with no data.-1 – Error. |
Name_STATUS_MESSAGE | Success.Query returned no data.Error. |
Name_STATUS | 1 – Success with data.101 – Success with no data.Other values – error. |
Name_RESULT | The results of the lookup |