Adding user defined parameters to an ODBC data source

ODBC data sources normally use a hard-coded query to retrieve data.  However, EasyCatalog allows elements of the query to be user definable or ‘parameter’ based.  These parameters are shown on the ‘info’ dialog box, accessible from the binocular icon on the data panel.  Any changes made are applied the next time the data is synchronized.

Parameters are defined using double curly braces.  Executing the query then prompts for the parameters by name. A maximum of 4 can be defined. Optional default  values can be configured using the colon separator. For example:

SELECT * from PRODUCTS where ID = {{Catalog ID:99}}

This defines a parameter called “Catalog ID” with a default value of “99”