Product Home
DTM Query Reporter Online Documentation
General information
Product profile
Connect
Report options
Profiles
Product settings
Query customization
Command Line
Additional information
Database utilities
Licence agreement
Demo and Full versions
Product ordering
Install
Uninstall
Upgrade
Support
Glossary

Query customization

The program supports dynamic statements as well as static statements. Their final state will be defined at the moment of execution. To make it possible, special tags (like ?1, ?2, etc.) are inserted into the text of a statement. Those tags will be replaced with the values from the values file. They are always replaced, even inside string constants.

The file with values is a text file. Each line in it corresponds to one value (?n). If there are more tags than values, tags with bigger numbers will not be replaced with any values.

There two formats of values file: 'by position' or 'by name'. For 'by position' format parameters should be located sequentially, for example:
value1
value2
value3

?1 will be associated to value1, ?2 to value2, etc

With 'by name' format you should use '?n=' prefix for each value. For example:
?2=value2
?1=value1
?3=value3