The idea of template queries is too provide a query with replaceable parameters that can be changed between query calls with out having to reform the queries. 6.1 Setting Them Up To set up a template query simply enter the query like it is a normal query. Don't quote or escape no matter what. Q Quote but don't escape based on the same rules. Always quote and escape even if it is a number.
Name can contain any alpha-numeric characters or the underscore.
If this is not the case add a column after the name. If you need to represent an actual colon after the name follow the name by two-columns. The first one will end the name and the second one won't be processed. The parameters can either be set when the query is executed or ahead of time by using default parameters. Where parm0 corresponds to parameter number 0, etc.