|
OpenRPT Product Guide |
|
|
OpenRPT Product Guide |
| 2.5. Resulting Standard SQL | ||
|---|---|---|
 | 2. MetaSQL Editor |  |
One of the most powerful features of the MetaSQL Editor is the ability to view the standard SQL generated by the MetaSQL parser. This is the same standard SQL the parser sends to the database for processing. This visibility is especially helpful when attempting to troubleshoot lengthy queries having complex MetaSQL statements and numerous parameters. To view the standard SQL output, select the option from the menu. The following screen will appear:
As you can see, the MetaSQL parser has stripped the MetaSQL elements from the original query to produce standard SQL which can be processed by the database.
If you save your MetaSQL queries to a local file, you can load them into the MetaSQL Editor at a later time. Parameter lists may not be saved, however.
This concludes the section on using the MetaSQL Editor. Again, we used a very simple query to illustrate the basic mechanics of the MetaSQL Editor. We encourage you to test more complex queries and parameter lists on your own.
| |  | |
| 2.4. Parsing and Executing a Query |  | 3. Report Renderer |