Parameterized Queries allow data gathered from an ODBC connection to be more dynamic. Within a SQL query, you can use the values of other Placeholders in the template as part of your query.
For example:
SELECT column1 FROM table WHERE column2 = ‘&PlaceholderName'
In this example, &PlaceholderName will be replaced by the value of the field named 'PlaceholderName' before the query is executed.
Note:
Ensure the syntax used for the SQL query is valid. The 'PlaceholderName' that is contained in the SQL query cannot contain any spaces.