Procedure Wizard Data Parameters

If you are creating an Insert or Update procedure, you must assign data parameters to specify the entity attributes or recordset fields that will be written to by this procedure.

When you create a new procedure, Host Integrator lists all the columns from the current table.

Read parameter from
This column specifies which attributes or recordsets this procedure writes data to. To enter a data destination, click the down arrow in the right side of the Read parameter from column. Host Integrator displays all the 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 able to write to, select a data destination.

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

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