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.
|