Queries

DBISAM Manager provides two powerful tools for working with the SQL queries: SQL Editor for editing the query text directly and Visual Query Builder for building queries visually.

Create Query

To create a new query in the SQL Editor

1

Select the Tools | New SQL Editor menu item.

2

Click the New Query button on the toolbar.

3

Edit the query text on the Edit tab of the SQL Editor.

To create a new query in the Query Builder

1

Select the Tools | New Query Builder menu item.

2

Build the query on the Builder tab of the Visual Query Builder.

Open Query

To open a query in the SQL Editor

1   Select the Tools | Show SQL Editor menu item.

2   Use the number buttons at the bottom of the area to find one of the previously edited queries. The last edited query is displayed automatically on opening the editor.

or

2   Click the Load button on the toolbar to load the query text from an *.sql file.

To open a query in the Query Builder

1

Select the Tools | Show Query Builder menu item.

2

The last edited query is displayed on the Builder tab.

3

To load a query from an *.sql file click the Load button on the toolbar.

Execute Query

To execute a query

1

Create a new query or open the existing one.

2

Click the Execute button on the toolbar of the SQL Editor or Visual Query Builder respectively.

3

View/edit the returned data on the Results tab.

Save Query

To save a query

1

Create a new query or open the existing one.

2

Click the Save button on the toolbar of the SQL Editor or Visual Query Builder respectively to save the current query.

or

2   Click the Save All button on the SQL Editor toolbar to save all the opened queries to one file.