SQL Data Manager GUI Visual Reference

This section describes the objects on the SQL DM graphical user interface (GUI).

Main Window

The following image shows the main window of the GUI. The table below the image describes the GUI objects. By default, Query Builder Diagram and Query Builder Grid are hidden when you start SQL DM.

GUI Object	Description	Related Information
Title Bar	Shows the following information: name of the utility name of the computer on which the database resides (if a database is open) name of the open database (if one is open) (For example, in Figure 6-9 the open database is DEMODATA on machine DOCLAB2.)
File menu	Provides the following commands: New SQL Query Open SQL Query Save SQL Query Save SQL Query As Open Database Close Database Print Page Setup Exit
New SQL Query command or icon	Creates a new SQL script in Query Pane. Clears Query Pane and positions the statement indicator at the top of the pane.	Query Pane To create an SQL query or script
Open SQL Query command or icon	Opens an SQL script and places its contents into Query Pane.	Query Pane To open an SQL script
Save SQL Query command or icon	Saves the SQL statement(s) in Query Pane as an ASCII file called an SQL script.	Query Pane To save an SQL query as a script
Save SQL Query As	Saves the SQL statement(s) in Query Pane as an ASCII file called an SQL script. If you have an SQL script already open, this command lets you save the statements with a different file name.	Query Pane To save an SQL query as a script
Open Database	Opens a database for use within SQL DM. If a database is already open, SQL DM closes it and opens the one you specify.	To open a database
Close Database	Closes the database currently open in SQL DM.	To close a database
Print	Allows you to specify options for printing the contents of Query Pane.	Query Pane To print the contents of Query Pane
Page Setup	Allows you to specify options for the layout of the printed page.	To layout the printed page
Exit	Terminates the execution of SQL DM. Prompts you to save the contents of Query Pane if the contents have changed.	To exit SQL DM
Edit menu	Provides the following commands: Undo (Control+Z) Cut (Control+X) Copy (Control+C) Paste (Control+V) Select All (Control+A) Find (Control+F) Find Next (F3) Replace (Control+H)
Undo (Control+Z)	Cancels typing actions performed in Query Pane. May be repeatedly performed for multiple undo actions.	Query Pane To cancel (undo) typing actions in Query Pane To cancel an Undo action (redo) in Query Pane
Cut (Control+X)	Removes selected text from Query Pane and places it in the clipboard.	Query Pane To cut or delete text from Query Pane
Copy (Control+C)	Copies selected text from Query Pane and places it in the clipboard.	Query Pane To copy text from Query Pane
Paste (Control+V)	Pastes clipboard text into Query Pane at cursor position.	Query Pane To paste within Query Pane
Select All (Control+A)	Selects all of the contents of Query Pane.	Query Pane To select text in Query Pane
Find (Control+F)	Finds a string in Query Pane.	Query Pane To find text in Query Pane
Find Next (F3)	Searches for the last string specified for the Find actions.	Query Pane To find text in Query Pane
Replace (Control+H)	Replaces one string with another in Query Pane.	Query Pane To replace text in Query Pane
View menu	Provides the following commands: Query Pane Query Builder Diagram Query Builder Grid Set Font Word Wrap
Query Pane command or icon	Shows or hides Query Pane. By default, Query Pane is shown when you start SQL DM. A database must be open to enable this command or icon.	Query Pane To show or hide Query Pane
Query Builder Diagram command or icon	Shows or hides Query Builder Diagram. A database must be open to enable this command or icon.	Query Builder Diagram To show or hide Query Builder Diagram To build a SELECT statement with Query Builder To build an UPDATE statement with Query Builder To build an INSERT statement with Query Builder To build a DELETE statement with Query Builder
Query Builder Grid command or icon	Shows or hides Query Builder Grid. A database must be open to enable this command or icon.	Query Builder Grid To show or hide Query Builder Grid To build a SELECT statement with Query Builder To build an UPDATE statement with Query Builder To build an INSERT statement with Query Builder To build a DELETE statement with Query Builder
Set Font command or icon	Set the font family, style, size, and script. The font characteristics apply to all text in Query Pane. By default, SQL DM sets the font characteristics to Courier Regular 10, Western script.	Query Pane To set the font for Query Pane
Word Wrap	Wraps text within Query Pane. A checkmark beside the command indicates that word wrap is active.	To wrap text within Query Pane
Tools menu	Provides the following commands: Query Query Builder Active Grid Properties
Query	Provides the following commands: Run Current SQL Statement in Grid Run Current SQL Statement in Text Run All SQL Statements Stop Continue Clear
Run Current SQL Statement in Grid command or icon	Runs the current statement in Query Pane and places the results on the Grid Results tab if the statement is a SELECT statement. If the current statement is not a SELECT statement, the results are placed on the Text Results tab. This command is enabled if a database is open and one or more SQL statements are present in Query Pane.	Results Tabs Query Pane To set Grid Results to allow changes to database data To set SQL statement separator To run a single SQL statement
Run Current SQL Statement in Text command or icon	Runs the current statement in Query Pane and appends the results on the Text Results tab. This command is enabled if a database is open and one or more SQL statements are present in Query Pane.	Text Results Tab Query Pane To set SQL statement separator To run a single SQL statement
Run All SQL Statements command or icon	Runs all statements in Query Pane starting with the statement at the top. Output is placed on the Text Results tab, never on the Grid Results tab. The output is appended to any results that already exists on the Text Results tab. This command is enabled if a database is open and one or more SQL statements are present in Query Pane.	Text Results Tab Query Pane To set SQL statement separator To run all SQL statements
Stop command or icon	Interrupts the current statement(s) being run. The statement indicator positions to the statement in Query Pane that was being run when the interruption occurred. In addition, the Text Results tab lists the statement that was last run. If you are running a statement for output to the Grid Results tab, any results are cleared on the tab. An SQL statement(s) must be running to enable this command.	To set a query time-out period To stop running SQL statements To continue running SQL statements that were stopped
Continue	Continues running a script that was interrupted with the Stop command or Stop icon, or that stopped running because of an error.	To stop running SQL statements To continue running SQL statements that were stopped
Clear command or icon	Clears all results on the Text Results tab. This icon is active only if the Text Results tab contains output. A database must be open to enable this command or icon.	To clear results from Text Results tab
Query Builder	Provides the following commands: Change Query Type Add Table Group By	To show or hide Query Builder Diagram
Change Query Type command or icon	Changes the type of statement being built with Query Builder. The choices for type are SELECT, INSERT, UPDATE, and DELETE. This command is enabled if a database is open and Query Builder Diagram or Query Builder Grid is enabled.	Query Builder Grid To set query type for Query Builder
Add Table command or icon	Adds a table to Query Builder Diagram (so you may select fields from the table). This command is enabled if a database is open and Query Builder Diagram or Query Builder Grid is enabled.	Query Builder Diagram Query Builder Grid To add a table to Query Builder Diagram To remove a table from Query Builder Diagram
Group By command or icon	Specifies a GROUP BY clause in a SELECT statement when you build an SQL statement with Query Builder. This command is enabled if a database is open and Query Builder Diagram or Query Builder Grid is enabled.	Query Builder Diagram Query Builder Grid To add a Group By column to Query Builder Grid To remove a table from Query Builder Diagram
Active Grid	Sets the Grid Results grid to active or display-only. An active grid allows you to change values in the cells, which changes the data values in the database provided you have the proper database permissions. By default, the grid is active.	To set default behavior for Grid Results tab
Properties	Sets the default behavior of the Grid Results grid, the SQL statement delimiter and the query time-out value.	To set default behavior for Grid Results tab To set SQL statement separator To set a query time-out period
Help menu	Provides the following commands: How Do I? Topics SQL Reference Search Documentation What's This? Glossary Online Manuals (Web) Knowledge Base (Web) Developer Center (Web) About Pervasive.SQL Data Manager
How Do I?	Lists the tasks that you can perform with SQL DM.	SQL Data Manager Tasks To display help
Topics	Lists the documentation topics pertaining to SQL DM.	To display help
SQL Reference	Displays an alphabetical list of SQL statements and keywords that are links to the SQL Engine Reference.
Search Documentation	Searches for a string throughout the installed set of Pervasive.SQL documentation.	To display help
What's This?	Identifies objects in the SQL DM GUI.	SQL Data Manager GUI Visual Reference To display help
Glossary	Defines terms used in the Pervasive.SQL documentation.	To display help
Online Manuals (Web)	Directs your browser to www.pervasive.com where you can reference the online manuals.	To display help
Knowledge Base (Web)	Directs your browser to www.pervasive.com where you can query the Pervasive.SQL Knowledge Base for additional information about Pervasive.SQL.	To display help
Developer Center (Web)	Directs your browser to www.pervasive.com where you can research information specifically for application developers using Pervasive.SQL.	To display help
About Pervasive.SQL Data Manager	Displays the name and version of SQL DM and the Pervasive.SQL copyright information.	To display help
	Moves the cursor to the first line in Query Pane and runs that statement. The statement indicator, the yellow arrow in the left margin of Query Pane, indicates the statement in which the cursor is located.	Query Pane To move the cursor within Query Pane without running any SQL statements To move the cursor within Query Pane and run the SQL statement to which it moves To set SQL statement separator
	Moves the statement indicator to the previous line in Query Pane and runs that statement. The statement indicator, the yellow arrow in the left margin of Query Pane, indicates the statement in which the cursor is located.	Query Pane To move the cursor within Query Pane without running any SQL statements To move the cursor within Query Pane and run the SQL statement to which it moves To set SQL statement separator
	Moves the statement indicator to the next line in Query Pane and runs that statement. The statement indicator, the yellow arrow in the left margin of Query Pane, indicates the statement in which the cursor is located.	Query Pane To move the cursor within Query Pane without running any SQL statements To move the cursor within Query Pane and run the SQL statement to which it moves To set SQL statement separator
	Moves the statement indicator to the last line in Query Pane and runs that statement. The statement indicator, the yellow arrow in the left margin of Query Pane, indicates the statement in which the cursor is located.	Query Pane To move the cursor within Query Pane without running any SQL statements To move the cursor within Query Pane and run the SQL statement to which it moves To set SQL statement separator
Query Pane	Accepts SQL statements typed into the pane or added with Query Builder. By default, Query Pane is shown (it may be shown or hidden).	Query Pane To create an SQL query or script To show or hide Query Pane
Results Grid	Shows in a spreadsheet-like format the output of SELECT statements.	Grid Results Tab To set SQL statement separator To set Grid Results to allow changes to database data To copy data from Grid Results tab to clipboard
Grid Results tab	Displays the Results Grid tabbed dialog.	Grid Results Tab To work with grid results
Text Results tab	Displays the Text Results tabbed dialog.	Text Results Tab To work with text results
Progress indicator	Displays a progress bar (a series of moving blue squares) to indicate that SQL DM is currently processing an action. The progress bar stops displaying after an action completes.
Insert/Overtype indicator	Shows whether Query Pane and the grid on the Grid Results tab are in insert or overtype mode. Insert mode adds characters between other characters as you type. Existing characters are pushed to the right. Overtype mode replaces characters as you type. The default mode is insert. When this field shows OVR in boldface, SQL DM is in overtype mode. When OVR shows in a dimmed typeface, SQL DM is in insert mode.	Query Pane To toggle insert/overtype mode
Rows fetched indicator	Displays the number of rows returned for a SELECT statement.	Records Affected and Scrolling

Query Builder Diagram

The following image shows the pane for Query Builder Diagram. Two tables, "Person" and "Billing," are open in the pane. When shown, Query Builder Diagram always appears as the first pane below the main window toolbar.

Query Builder Grid for SELECT Statements

The following image shows Query Builder Grid for SELECT statements. The table below the image describes the GUI objects.

GUI Object	Description	Related Information
Column	Shows the name of the database column being used in the SQL statement. Column names are fully qualified with the table name (table_name.column_name).	Query Builder Grid To build a SELECT statement with Query Builder
Alias	Shows the alternate name for a column. The alias name appears in an AS clause. The alias also appears as the column title in the results on the Grid Results tab and the Text Results tab.	Query Builder Grid To build a SELECT statement with Query Builder
Table	Shows the name of the table with which the column is associated.	Query Builder Grid To build a SELECT statement with Query Builder
Result	Specifies whether to include the column in Query Pane. An "X" in the option square includes the column in the SQL statement. Lack of an "X" excludes the column.	Query Builder Grid To build a SELECT statement with Query Builder
Order by	Specifies the priority by which the columns will be sorted in the result. The following choices are available: Ascending Descending Unsorted The default is unsorted.	Query Builder Grid To build a SELECT statement with Query Builder
Group by	Specifies that the column is being used in a GROUP BY clause or as part of an aggregate query. The Group By column appears only if you click Tools4Query Builder4 Group By or click . Group By provides the following aggregate functions: Group By (the default) AVG (average) COUNT MAX (maximum) MIN (minimum) SUM	Query Builder Grid To build a SELECT statement with Query Builder
Criteria	Specifies a search condition for the associated column. The default operator is equals (=). Text literals are automatically single quoted when you move from the Criteria cell. The criteria acts as a filter to restrict the number of rows a SELECT statement returns. The following operators are recognized as search criteria for a value: BETWEEN expression AND expression NOT BETWEEN expression AND expression IN NOT IN IS NULL IS NOT NULL LIKE NOT LIKE = (equals) < (less than) > (greater than) <= (less than or equal to) >= (greater than or equal to) <> (not equal to)	Query Builder Grid To build a SELECT statement with Query Builder
Or	Specifies an additional search condition linked to the previous criteria by a logical OR. Note: The grid does not contain a column for a logical AND. The task To build a SELECT statement with Query Builder explains how to construct a logical AND.	Query Builder Grid To build a SELECT statement with Query Builder

Query Builder Grid for UPDATE Statements

The following image shows Query Builder Grid for UPDATE statements. The table below the image describes the GUI objects.

Query Builder Grid for INSERT Statements

The following image shows Query Builder Grid for INSERT statements. The table below the image describes the GUI objects.

Query Builder Grid for DELETE Statements

The following image shows Query Builder Grid for DELETE statements. The table below the image describes the GUI objects.