We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Run sql on the collection server
Run a sql statement against the collection server
| Parameter | Description |
|---|---|
| cmd | Name of the collection server to get data from |
| Argument 0 | Connection String for the collection server database |
| Argument 1 | Temp Table Prefix - each table returned has an index from 1 to the number of tables in the dataset (number of tables selected) |
| Argument 2 | Wait timeout period |
| Argument 3 | Data format for coll to app server communication. Blank or "Xml" will return XML, "BINARY" will use the dataset binary formatting. Both forms will be zipped |
| Argument 4 | Clean Strings - defaults to true |
ExecuteTextColl "Name of the collection server to get data from", "Connection String for the collection server database", "Temp Table Prefix - each table returned has an index from 1 to the number of tables in the dataset (number of tables selected)", "Wait timeout period", "Data format for coll to app server communication. Blank or "Xml" will return XML, "BINARY" will use the dataset binary formatting. Both forms will be zipped", "Clean Strings - defaults to true"