SQL Execution |

Executing the converted SQL
### Executing the converted SQL Before executing any query, the database connections have to be configured first. Please look at Connecting to databases section for details. In the "Converted SQL" text area, select the required Database tab If there are multiple queries then select the required SQL query The Execute option can be invoked in the following ways: Select "Execute" menu item and choose the required Database name (or) Select "Execute" tool bar icon in "Converted SQL" text area (or) Right click on "Converted SQL" text area and choose "Execute" menuitem The results of the query will be displayed in the "Result Set" text area Error Handling: When the input SQL is syntactically incorrect or if SwisSQL Console can not recognize the SQL then "Parse Failure" will be displayed in "Converted SQL" area. To know more about the error click on "Messages" tab. When you encounter error during execution of the converted SQL, then an error dialog will be displayed. The error message received from the database will be displayed in the dialog box

© 2011 ZOHO Corporation