Product Home
DTM Query Reporter Online Documentation Prev Page Prev Page
General Information
Product Profile
Connect
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Report Options
Profiles
Product settings
Query Customization
Command Line
SQL Console
Execution Console
Tuning and Localization
Additional Information
Database Utilities
Licence Agreement
Demo and Full versions
Product Ordering
Install
Uninstall
Upgrade
Support
Trademark Information
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 value 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