Home
SQL Select online help Prev Page Prev Page
Introduction
About SQL Select
Version history
Supported database engines
Contact us
Using SQL Select
Connecting to a database server
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
The SQL workspace
SQL editor
Query selection
Data sets
Locking data sets
Exporting data sets
Export to text file
Export to Excel
Export to SQLite

Data sets

The results of your SQL queries are displayed as data sets in the bottom panel of the SQL workspace.

ide17a  

For binary type fields, SQL Select will try to identify the data type stored in the column, and display the type (if known) and the binary data size.

clip0002

SQL Select can identify the following file formats:

· images (png, gif, jpeg, tif, bmp, psd)  
· Adobe Acrobat files (pdf)  
· Microsoft Office files (Excel, Word, Powerpoint)  
· archives (zip, rar, 7z, bzip2, gzip)  
· multimedia files (avi, mp3, wav)  
· text files (rtf, html, xml)  
· help files (hlp, chm)  
· Windows executable files (16-bit, 32-bit, and 64-bit exe)  
· Windows libraries (16-bit, 32-bit, and 64-bit DLL)  
· DOS applications  


The Field details
tab displays the list of fields returned by the query, and the display type.

ide19a