VLDQUERY
Usage
TIBCO iProcess Workspace (Windows)
Warning: (iProcess only) This expression is not available to the TIBCO iProcess Script Server Plug-in. Therefore, even though you can successfully enter the expression in your iProcess Script plug-in definition, it will not be processed by the iProcess Engine. It will return SW_NA.
Passes a query to an integrated database (for example, Oracle) and adds the resulting values to the validations list for the current field.
Note: There is no action if the iProcess Engine is not integrated with a database.
Syntax
VLDQUERY (query, limit)
where:
| • | query is a text string specifying an SQL query. |
| • | limit is a numeric value specifying the maximum number of validations to add to the validations list (subject to the overall limit specified by the MAXVLD entry in the SWDIR\etc\staffcfg file, or 1000 if there is no such entry). |
Returns
The number of validations added to the validations list - not normally used.
Examples
TIBCO iProcess Modeler:
VLDQUERY ("select partno from parts where type=3", 50)
TIBCO Business Studio:
IPEValidationUtil.VLDQUERY("select partno from parts where type=3", 50);