GUI ISQL

GUI SQL makes interacting directly with SQL easier. It provides a graphical interface to the openisql program .

Starting GUI ISQL

Using the OpenBase Manager you click on the icon next to the database you want to use GUI ISQL with.
droppedImage-1.jpg
If you need to start GUI ISQL without launching the OpenBase Manager, it is installed on your computer.

On a standard OS X install GUI ISQL is located in /Applications/OpenBase/

Using GUI ISQL

Once you have started GUI ISQL you will see a window like the following on OS X. Notice that the windows title reflects the user name you logged in with. When started from the OpenBase Manager this will be the admin user.

picture3.jpg
You can start a new connection in GUI ISQL with a different user name and password using the File Menu’s Connect To Database option.

Once you are connected GUI ISQL will query the database and generate a list of Template queries.

These queries are set up to select all columns from any of the tables in the database.

You can use them as starting points for queries of your database.

As well, once connected GUI ISQL generates templates for using any of the Stored Procedures in the database and creates a template call for each stored procedure. These are shown in the Procedures pop up menu. GUI ISQL remembers the last 100 queries you execute.

Pressing the button moves backwards through executed commands

Pressing the button moves forwards through executed commands

picture4.jpg
Pressing the button clears the contents of the query windowpicture5.jpg
To run the command you can press the Go button or press Return while editing the query.
picture6.jpg

Named Queries

When you are working with a database you may have queries that you need to repeat frequently.

GUI ISQL allows o to store queries and name them. The queries are stored locally and associated with the database and host. Any time you log in to this particular database and host, you will see and additional pop up menu of Named Queries that are the queries you have saved previously.

Any time you enter a query that you want to keep for subsequent use, you need to have the text of the query in the query editor.

When you have the query just right, and it’s in the query editor, the Name Query option in the Queries menu will be enabled.

Enter a name for you query that identifies it in the list of existing named queries. Note that the naming process will NOT let you accidentally use a name that is already in use.

Names do NOT have to be unique across ALL named queries, only those associated with the host and database your are logged in to.

If you should find that you need to remove a named query, use the Browse Queries option in the Queries menu.

This permits you to see what queries you have for all hosts, and databases.

Note that you can not add or modify queries in the tool. You can only view and remove queries.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License