Introduction

About SQL Data Sets

Version history

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

Connecting to an Oracle database

The SQL workspace

SQL editor

Data sets

HTML export

Adding and viewing notes

Viewing images

Creating a package

Options

Using SQL Data Sets Viewer

Opening a package

Local queries

Local SQL commands and functions

Miscellaneous topics

Registering

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.



Details of the image are displayed as a hint.



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:



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