SQL Executor

You can send SQL queries to the connected MySQL database and display the result. The queries can contain UPDATE, DELETE, INSERT statements, and SELECT statements as well. Note, that it possible to run multiple SQL queries simultaneously.

The result of the SELECT-containing queries will be shown in the grid-based dialogs.

To execute SQL queries:

1. Connect to the database using Database Connection Manager.
   or
   Use the already established database connection.
2. Call the SQL Executor by selecting Database | SQL Executor menu item or pressing Ctrl-Shift-E. 
3. Enter one or more SQL queries.
4. Press F9 or click the Execute SQL button in the toolbar of dialog to execute your queries.
   A data grid window will be displayed for each SELECT-based query.
   To close the data grid window, click on the Close button.
   The execution status for each query will be shown in the bottom of the SQL Executor dialog. 
5. You can save typed queries a the file. Click on the Save () button on the SQL Executor toolbar.

Please note, that SQL Executor dialog is used by Database Generation and Database Modification tools.

Database Generation: Database Generation

Database Functions: Database Modification

©2005 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.