Query Completion


Query completion is a handy feature available from within the Query Panel of goat. Basically it pops up a drop-down menu at the cursor displaying multiple choices to the user to select from. This feature allow for the following completion mechanisms :

All of these flavors can also be accessed by clicking Tools->Query Completion

The query completion dialogs can also be invoked by pressing the period ".". For example the column list popup can be displayed if the user types in "select * from ACCOUNTS." (where ACCOUNTS is a table name). This will bring up a popup displaying the columns of the table "accounts".

Query completion popups can also be displayed from an table alias. So if the user typed in a query as follows :

"select acc. from accounts acc" , a popup will appear which will display the available columns of the table "accounts", which has been aliased as "acc". Note that for this to work, you need to define the alias before you try to access the columns of the aliased table.

Here are sample images of each of the above query-completion dialogs for the system :


Table List
Table Query Completion
Back to top


Functions
Functions
Back to top


Data Types
Data Types
Back to top


Columns
Columns
Back to top