1.1.3 Adding a Query Parameter

#1.1.3 Adding a Query Parameter

In Figure 11, in the WHERE blog part of the query, for example, to add a search parameter based on the OSUSERS.ID field, type WHERE OSUSERS.ID = '', and then click the Add parameter button while the cursor is between the '' marks. Note: The parameter expression is enclosed in double quotation marks ('') only if the type of the parameter is string or datetime. Parameter type; If it is integer, double, or boolean, it is not written between double quotes.

In Figure 12, the parameter name is typed in the Name field and the description is written in the Description field. The Type field selects the parameter type, and the Length field selects the length field. If the parameter is required, the Required option is checked.

Click the Save and Compile button to run the query.

The record returned as a parameter result is shown in Figure 15. Click the Next button.

To name the columns returned as a result of the query, the Finish button is clicked after the description is written in the Caption header opposite the corresponding field in Figure 16.