SQL Data Manager GUI Visual Reference

---

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

• Main Window
• Query Builder Diagram
• Query Builder Grid for SELECT Statements
• Query Builder Grid for UPDATE Statements
• Query Builder Grid for INSERT Statements
• Query Builder Grid for DELETE Statements

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. Click on an area of the image for which you want more information.

 
Figure 6-9 SQL Data Manager Main Window

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.)	(Main Window image)
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	(Main Window image)
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 (Main Window image)
Open SQL Query command or icon	Opens an SQL script and places its contents into Query Pane.	Query Pane To open an SQL script (Main Window image)
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 (Main Window image)
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 (Main Window image)
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 (Main Window image)
Close Database	Closes the database currently open in SQL DM.	To close a database (Main Window image)
Print	Allows you to specify options for printing the contents of Query Pane.	Query Pane To print the contents of Query Pane (Main Window image)
Page Setup	Allows you to specify options for the layout of the printed page.	To layout the printed page (Main Window image)
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 (Main Window image)
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)	(Main Window image)
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 (Main Window image)
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 (Main Window image)
Copy (Control+C)	Copies selected text from Query Pane and places it in the clipboard.	Query Pane To copy text from Query Pane (Main Window image)
Paste (Control+V)	Pastes clipboard text into Query Pane at cursor position.	Query Pane To paste within Query Pane (Main Window image)
Select All (Control+A)	Selects all of the contents of Query Pane.	Query Pane To select text in Query Pane (Main Window image)
Find (Control+F)	Finds a string in Query Pane.	Query Pane To find text in Query Pane (Main Window image)
Find Next (F3)	Searches for the last string specified for the Find actions.	Query Pane To find text in Query Pane (Main Window image)
Replace (Control+H)	Replaces one string with another in Query Pane.	Query Pane To replace text in Query Pane (Main Window image)
View menu	Provides the following commands: Query Pane Query Builder Diagram Query Builder Grid Set Font Word Wrap	(Main Window image)
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 (Main Window image)
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 (Main Window image)
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 (Main Window image)
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 (Main Window image)
Word Wrap	Wraps text within Query Pane. A checkmark beside the command indicates that word wrap is active.	To wrap text within Query Pane (Main Window image)
Tools menu	Provides the following commands: Query Query Builder Active Grid Properties	(Main Window image)
Query	Provides the following commands: Run Current SQL Statement in Grid Run Current SQL Statement in Text Run All SQL Statements Stop Continue Clear	(Main Window image)
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 (Main Window image)
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 (Main Window image)
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 (Main Window image)
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 (Main Window image)
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 (Main Window image)
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 (Main Window image)
Query Builder	Provides the following commands: Change Query Type Add Table Group By	To show or hide Query Builder Diagram (Main Window image)
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 (Main Window image)
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 (Main Window image)
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 (Main Window image)
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 (Main Window image)
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 (Main Window image)
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	(Main Window image)
How Do I?	Lists the tasks that you can perform with SQL DM.	SQL Data Manager Tasks To display help (Main Window image)
Topics	Lists the documentation topics pertaining to SQL DM.	To display help (Main Window image)
SQL Reference	Displays an alphabetical list of SQL statements and keywords that are links to the SQL Engine Reference.	SQL Reference (Main Window image)
Search Documentation	Searches for a string throughout the installed set of Pervasive.SQL documentation.	To display help (Main Window image)
What's This?	Identifies objects in the SQL DM GUI.	SQL Data Manager GUI Visual Reference To display help (Main Window image)
Glossary	Defines terms used in the Pervasive.SQL documentation.	To display help (Main Window image)
Online Manuals (Web)	Directs your browser to www.pervasive.com where you can reference the online manuals.	To display help (Main Window image)
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 (Main Window image)
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 (Main Window image)
About Pervasive.SQL Data Manager	Displays the name and version of SQL DM and the Pervasive.SQL copyright information.	To display help (Main Window image)
	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 (Main Window image)
	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 (Main Window image)
	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 (Main Window image)
	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 (Main Window image)
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 (Main Window image)
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 (Main Window image)
Grid Results tab	Displays the Results Grid tabbed dialog.	Grid Results Tab To work with grid results (Main Window image)
Text Results tab	Displays the Text Results tabbed dialog.	Text Results Tab To work with text results (Main Window image)
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.	(Main Window image)
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 (Main Window image)
Rows fetched indicator	Displays the number of rows returned for a SELECT statement.	Records Affected and Scrolling (Main Window image)

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. Click on an area of the image for which you want more information.

 
Figure 6-10 Query Builder Grid for SELECT Statements

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 (Query Builder Grid for SELECT Statements image)
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 (Query Builder Grid for SELECT Statements image)
Table	Shows the name of the table with which the column is associated.	Query Builder Grid To build a SELECT statement with Query Builder (Query Builder Grid for SELECT Statements image)
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 (Query Builder Grid for SELECT Statements image)
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 (Query Builder Grid for SELECT Statements image)
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 (Query Builder Grid for SELECT Statements image)
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 (Query Builder Grid for SELECT Statements image)
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 SELECT Statements image)

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. Click on an area of the image for which you want more information.

 
Figure 6-11 Query Builder Grid for UPDATE Statements

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 an UPDATE statement with Query Builder (Query Builder Grid for UPDATE Statements image)
Table	Shows the name of the table with which the column is associated.	Query Builder Grid To build an UPDATE statement with Query Builder (Query Builder Grid for UPDATE Statements image)
New Value	Specifies the value used to replace (update) a value in an existing column.	Query Builder Grid To build an UPDATE statement with Query Builder (Query Builder Grid for UPDATE Statements image)
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 specifies the data that you want to change. 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 an UPDATE statement with Query Builder (Query Builder Grid for UPDATE Statements image)
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 an UPDATE statement with Query Builder To build a SELECT statement with Query Builder (Query Builder Grid for UPDATE Statements image)

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. Click on an area of the image for which you want more information.

 
Figure 6-12 Query Builder Grid for INSERT Statements

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 an INSERT statement with Query Builder (Query Builder Grid for INSERT Statements image)
New Value	Specifies the value to be inserted into an existing column.	Query Builder Grid To build an INSERT statement with Query Builder (Query Builder Grid for INSERT Statements image)

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. Click on an area of the image for which you want more information.

 
Figure 6-13 Query Builder Grid for DELETE Statement

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 DELETE statement with Query Builder (Query Builder Grid for DELETE Statements image)
Table	Shows the name of the table with which the column is associated.	Query Builder Grid To build a DELETE statement with Query Builder (Query Builder Grid for DELETE Statements image)
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 specifies the data that is used to identify the rows to delete. Note that a DELETE statement removes the entire row in which the criteria is found. If you want to change data and not remove it, use an UPDATE statement. 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 DELETE statement with Query Builder (Query Builder Grid for DELETE Statements image)
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 DELETE statement with Query Builder To build a SELECT statement with Query Builder (Query Builder Grid for DELETE Statements image)