Query Properties are properties of the Data Control. Query properties, QP1 through QP32, serve as variables in the query submitted to the database. These properties can be set to any value or can be animated by any object. To use query properties in a query, you can:
- Select them in the Create Row Filter dialog box of the SQL Wizard
- Enter them manually in an SQL Select or Update statement, using the following syntax:
{ts 'QPn'}
where n is an integer from 1 to 32.
If you use a stored procedure to query a database, VisiconX automatically assigns query properties to the parameters of the stored procedure.
The query properties act as placeholders in the query statement. In this example:
OrderDate={ts 'QP1'} and Customer= 'QP2'
the query substitutes values for QP1 and QP2; the resulting query might look something like this:
OrderDate={ts '1999-02-18 00:00:00'} and Customer= 'FOLKO'
You animate query properties through the Data Control. The query gets the substitution values from objects linked to the query property, such as an OLE object, a Data link, or another object control.
When you switch to run mode, the objects animated by the Data Control, such as the Grid Control, will appear empty until you select or enter a value in the object that is animating the query property. For example, suppose you animate the query property with the value selected in a ListBox Control. The list box value animates a query property in the Data Control, which in turn, determines the data displayed in the Grid Control.
For more information about animating objects, see the iFIX Creating Pictures manual.
