PCC
The PCC main window comprises editors and views:
“Pervasive PSQL Explorer”
You can display and work with objects through the different editors and views. Multiple editors of the same type (for example, SQL Editor) can be open at the same time. Each object being edited is represented by a tab on top of the editor. The tab contains the name of the object. Data modified within an editor must be explicitly saved (for example, with File Save).
Views, such as Pervasive PSQL Explorer, can be opened only one at a time. Actions performed within a view are applied immediately. No explicit save is required.
Editor and View Characteristics
The following table summarizes the characteristics of the editors and views.
Pervasive PSQL Explorer
This view displays a tree of objects that can be opened or expanded to reveal more detail. Click the expand icon to the left of an object to reveal subordinate objects. The expand icon may be a “+” symbol, a
“ ” symbol, or some other similar symbol. Click the collapse icon Table 3-3 Characteristics of PCC Window Views
Characteristic Pervasive
PSQL Explorer
SQL Editor Grid Text Outline Table Editor
Contains icons specific to that
view
Can be closed
Can be minimized
Can be maximized
Can be restored to previous size
Can be opened in new window
Can be rearranged within PCC
main window
Can be "pulled" from PCC and
placed on desktop
to hide subordinate objects. (The collapse icon appears after you click an expand icon.)
The tree of objects includes a root node named Pervasive PSQL. The root node contains subordinate objects such as clients, services (if applicable), engines, databases, tables, views, stored procedures, user-defined functions, triggers, groups, users, and system objects (such as system tables).
Figure 3-3 Example Objects Shown in Pervasive PSQL Explorer
Accessing Object Properties
A right-click on an object reveals actions or dialogs applicable to that object. For example, you can right-click on an object then click Properties to display configurable settings for the object (provided properties apply to the object). You may also click an object then press Alt+Enter to display properties.
SQL Editor
SQL Editor allows you to run Structured Query Language (SQL) statements against a Pervasive PSQL database. See “SQL Editor” on page 6-1 for a detailed discussion.
Grid
The Grid window view shows in a matrix format, like a spreadsheet, the result of running SQL statements. Each field is represented as a
column and the data appears in cells within the columns. You can change data directly in the Grid cells as well as add additional rows to the Grid.
Both Table Editor and SQL Editor use the Grid. See “To view table data” on page 5-13 and “Grid Window View” on page 6-4 for further details.
Text
The Text window view shows in a text format the result of running SQL statements. The text is display only. You cannot change data values by changing the text, but you can copy text. See “Text Window View” on page 6-5 for a detailed discussion.
Outline
The Outline window view allows you to view the SQL statements in a tree structure. The root node of the tree is the same name as the name of the SQL Editor window view. See “Outline Window View”
on page 6-7 for a detailed discussion.
Note that the editor must support an outline or the Outline window view is not available. Currently, only SQL Editor supports an outline view.
Table Editor
Table Editor allows you to add, delete, or change the characteristics of columns within a table. The table may be one newly created or an existing table that you want to edit. See “Table Editor” on page 5-1 for a detailed discussion.
Preferences
You can set general preferences for your experience in PCC. You can also set preferences for the window views in PCC or for the external tools.³ To set general preferences for Grid
1 On the PCC Window menu, click Preferences. Expand the Pervasive node if it is not already expanded.
2 Click General.
The following are the options that can be set in the General Preferences:
Always remove associated DSN entries (see “Deleting DSNs” on page 2-35)
Do not prompt for new database each time a SQL document is opened (see “To set database context for an SQL query” on page 6-14.
Select Always remove associated DSN entries to have all DSN entries for any database automatically deleted along with the database without prompting.
Unselect Do not prompt for new database each time a SQL document is opened to be prompted to select a database each time you open a SQL document in the SQL Editor. If this option is unselected, select it to use the most recently selected database when you open a SQL document. The selected database is not maintained across PCC sessions. If you close and reopen PCC, you will have to select a new default database context.
Preferences for PCC Window Views
You can set preferences for the following PCC window views:
Grid
SQL Editor
Table Editor
Text
³ To set preferences for PCC Window Views
1 On the PCC Window menu, click Preferences. Expand the Pervasive node if it is not already expanded.
2 Perform one of the following actions:
a. To set preferences for Data Grid, click Data Grid.
b. To set preferences for SQL Editor, click SQL Editor.
c. To set preferences for Table Editor, click Table Editor.
d. To set preferences for Text Output, click Text Output.