Script Language Print

QiD provides a script language that lets you automate and control queries. You can adjust settings, perform condition tests and branches (even loops) and control the destination of results. You can automatically send results to an Excel file or set up analysis grids with pre-defined filters and grouping. You can also include or execute SQL and script from external files.

[Image - Example Script]

You can use the script language facility to automate various checks and processes in, say, a reporting suite of queries. Add checking to ensure that the data is ready, and intermediate tests to ensure that the expected number of rows is being processed. Conditional testing can cause the query execution to cancel with an error message, or to branch off to a section of recovery code.

[Incomplete - List of Script commands]