Procedure Wizard Filter Parameters

Select, Update, or Delete procedures require filter parameters to specify which table columns can be acted upon by an SQL query. Filter parameters define the table column(s) that can be queried and indicate whether the column is required in an incoming SQL query.

Parameters
When you create a new procedure, the Host Integrator lists all the columns from the current table. You can use any of these columns as a filter that determines how the table can be queried by a client application.


Write parameter to

This column specifies which attribute or recordset this filter parameter is written to in order to fulfill this query. To enter a data destination, click the down arrow in the right side of this column. Host Integrator displays all attributes and recordset fields using the syntax Entity name.Attribute name for attributes, and Entity name.Recordset.Recordset field for recordset fields.

For each table column listed under Parameters that you want to be a filter parameter, click Write parameter to and select the attribute or recordset field to which this procedure will write the filter parameter.

 

Required
To make a filter parameter required, select the Required box next to it. Any query that does not specify this parameter will fail.


Click Next to proceed to the next step or click Finish to exit the Procedure Wizard.