Home
SQL Spreadsheets online help Prev Page Prev Page
Introduction
About SQL Spreadsheets
Version history
Contact us
Supported database engines
Using SQL Spreadsheets
Home page
SQL workbench
Command selection
Data sets
Exporting data sets
Exporting to text files
Exporting to Excel
Define column formats
Tasks
Task settings
DATETIME tag formatting options
Connect to database
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
SQL scripts
SQL tags
Image and file options
Define column formats
Delivery channels
Logging options
Finalise
Run task
Scheduling a task
Options

SQL workbench

The SQL Workbench is where you can connect to your databases, run queries, and export your result sets to Excel spreadsheets quickly.

Click on the Connect to database button to open the database connection page, or the SQL workbench > Connect to database
menu item. The parameters are identical to the connections page in the Tasks Wizard, described here.

The SQL editor is where you enter your SQL commands. You can load a SQL script by clicking on the sql_open_script (Load script...)
button on the toolbar. To save a script, click on the sql_save_script (Save script... ) toolbar button.

ide12a  

When you want to run a SQL command, select the block of text or use active text selection, then click on the execute (Execute query
) toolbar button, or F5. Any errors raised will be displayed in the Messages tab.

ide14a  

In addition to features offered by a text editor, the editor offers the following:

· active text selection  
You can run SQL queries in 2 ways. The regular way is to select the block of SQL text to run, then click on the execute (Execute query) toolbar button, or F5. The alternative is to place your caret anywhere in the SQL text, and click on the execute (Execute query) toolbar button, or F5. When you do not explicitly select a block of text, SQL Image Viewer will look for a block of text at the carets' position, surrounded by blank lines. See Editor command selection for details.  
 
· numbered bookmarks  
 
The editor allows you to create up to 10 bookmarks. To create a bookmark, press CTRL-SHIFT-[0 - 9]. To go to a bookmark, press CTRL-[0 - 9]. E.g. to place bookmark 1 at the current line, press CTRL-SHIFT-1.  
 
A bookmark indicator is displayed on that line. To jump to that bookmark from anywhere in the editor, press CTRL-1.  
 
ide16b  
 
· drag and drop editing  
 
You can select a block of text by highlighting it, then by clicking anywhere in the selected block, you can then drag and drop the selected block to anywhere else in the editor.  
 
· bracket highlighting  
 
When the caret is at the beginning or end of a block delimited by brackets, the corresponding bracket is highlighted.  
 
ide31