Home
SQL Data Sets - Online help Prev Page Prev Page
Introduction
About SQL Data Sets
Version history
Supported database engines
Contact us
Getting started
Creating a result set package
Opening and using a SQL Data Sets package
Using SQL Data Sets
Connecting to a database server
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
The SQL workspace
SQL editor
Data sets
HTML export
Adding and viewing notes
Viewing images
Creating a package
Exporting to a SQLite database
Options
Using SQL Data Sets Viewer
Opening a package
Local queries
Local SQL commands and functions

Viewing images

SQL Data Sets can display images stored in the data sets. In the current version of SQL Data Sets, the following image formats are supported:

· Bitmaps (bmp)  
· Graphic Interchange Format (gif)  
· Jpeg  
· Portable Network Graphics (png)  
· Photoshop (psd)  

To display an image, simply click on a cell containing the data. The Image viewer
displays the image.

image01  

Details of the image are displayed as a hint.

image11a  

SQL Data Sets can also identify various file formats that may be stored in a binary column. In the current version of SQL Data Sets, the following file formats are supported:

· Adobe Acrobat (pdf)  
· Bzip2 archives (bzip2)  
· unprotected Microsoft Office files (doc, xls, ppt)  
· Winrar archives (rar)  
· Zip archives (zip)  

When you select a cell that contains a file saved in any of the supported formats, SQL Data Sets displays an icon to represent the file type. For example, if we select a cell that contains a Microsoft Word document, SQL Data Sets displays the following in the image viewer:

binary02  

You can open the binary data by clicking on the Open
(open_n) toolbar item, or save the binary data to disk by clicking on the Save to disk (save) toolbar item.