Query in Multiple Categories |
Scroll |
TheMultiQuery allows you to specify and execute queries in multiple categories. It can be seen as a list of TheQuery objects returning a list of TheQueryResult objects. .
1 |
Connect to the Thereforeâ„¢ server (see "Server - Connect and Disconnect" for Details) |
2 |
Declare and initialize a new TheMultiQuery. |
3 |
Create and add two or more queries (see "Query in One Category" for more details on query specification). |
4 |
Execute the multi-query on the server. |
5 |
Optional. Display multi-query definition and results. |
Requirements and Assumptions: If these assumptions do not apply to your system or configuration please replace them with appropriate values when copying the code samples below. |
Advanced SQL Features Advanced SQL features such as grouping and joining tables are not yet supported by the Thereforeâ„¢ system.
Performance Note Combining several TheQuery instances in an TheMultiQuery and executing them together is more efficient than executing the queries individually. |