Home
SQL Image Viewer online help Prev Page Prev Page
Introduction
About SQL Image Viewer
Version history
Contact us
User Guide
System requirements
Editor command selection
Exporting large number of images
Folders and files
Reference Guide
Main menu
Connect to Database
Connecting to Firebird databases
Connecting to MySQL databases
Connecting to Oracle databases
Connecting to SQLite databases
Connecting to SQL Server databases
Connecting using ODBC
Connecting to a DB2 database
Connecting to a PostgreSQL database
Options
General options
Editor options
Thumbnail options
Image view
Check for updates
About
The work area
SQL editor
Table browser
Results
Other binary data
Image viewer
Hex viewer
Export items wizard
Exporting Microsoft Access OLE data
Image options
File naming convention
Datetime format specifiers
Command line interface
Parameters, logs and exit codes
Advanced options
CROP option
Troubleshooting
Expired trial
Invalid licenses
Unidentified images or binary data

Results

Once a query has completed running, the results are displayed on the Results tab.

results-thumbnails_b

On the top panel, images that were retrieved from the database are retrieved in one of three layouts:

· thumbnails  
 
layout-thumbnails  
 
When this layout is selected, images are grouped by records in a vertical format. The first text column in the result set is used to name the group. Each image is named after the column from which the image data is stored in.  
 
· tiled  
 
layout-tiled  
 
When this layout is selected, images are grouped by records in a vertical format, similar to the thumbnail layout. A summary of each image's attributes is displayed.  
 
· filmstrip  
 
layout-filmstrip  
 
When this layout is selected, images are grouped by records in a horizontal format. The first text column in the result set is used to name the group. Each image is named after the column from which the image data is stored in.  
 

If SQL Image Viewer does not recognise image formats that it claims to supports, see this topic for troubleshooting options.

Double clicking on any image will open that image in an Image viewer window. If that image was previously opened, the page containing that image will be made active. You can save an image to disk by first selecting that image, then bring up the context menu by right clicking on that image, and select the Save image...
item. You can also view the binary data for the selected item by selecting the View as hex item in the context menu.

results - save


On the bottom panel, the result set text data is displayed in a grid. Selecting an item in the grid will change the focus in the top panel to the corresponding record's group.

datagrid 02


You can switch to a text view by clicking on the 'Results in text
' (button - results to text) button.

results text