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

Locking data sets

You can lock data sets so that they are not cleared the next time a query is ran. For e.g. we have 2 data sets from a query we ran:

dataset01a  
 
We now want to keep the first data set, for reference purposes. We lock the data set by clicking on the Lock data set button (bookmark). The data set is now locked, and the description changes to Locked data set.

ide21a  

If you now run a new query, the locked data set is still available for viewing. This locked data set can also be exported together with the new data set. This feature allows you to keep multiple data sets, and export them together into the same Excel workbook or SQLite database.

ide22