Show All
Registering a parameter
Before you can use a parameter with a database-driven document created with the Database Wizard, you first need to register it. Registering a parameter creates a definition for the parameter in the document’s source code and allows it to be used in any database-driven block in the document. You can register a parameter either within the Database Wizard or after you have completed the wizard.
To register a parameter within the Database Wizard
- In step 4 of the wizard, Selection Statement, click the … button next to the Filter box and then click <Add New Argument>.
- Click Add. A new parameter will appear in the parameter list, and its name will be highlighted.
- Type a name for the parameter and press Enter.
- Double-click the word Integer in the Data type column, and then select the appropriate data type. (You should select the data type that matches the data type of the database field that the parameter will be used with in the filter condition. For example, if the parameter will be used with a numeric ID field, select Integer.)
- Click OK.
To register a parameter after completing the Database Wizard
- Right-click anywhere in the document, point to Database, and then click Document Properties.
- Click the Parameters tab.
- Click Add. A new parameter will appear in the parameter list, and its name will be highlighted.
- Type a name for the parameter and press Enter.
- Double-click the word Integer in the Data type column, and then select the appropriate data type. (You should select the data type that matches the data type of the database field that the parameter will be used with in the filter condition. For example, if the parameter will be used with a numeric ID field, select Integer.)
- Click OK.