Download Pervasive.SQL V8 User's Guide

SQL Data Manager
n
n
n
n
SQL DM is running (see “To start SQL DM as a stand-alone
application” on page 6-42 or “To start SQL DM from PCC” on
page 6-43)
The database DEMODATA is open (see “To open a database” on
page 6-44)
Both Query Builder Diagram and Query Builder Grid are
hidden (see “To show or hide Query Builder Diagram” on page
6-62 and “To show or hide Query Builder Grid” on page 6-62)
No tables are open in Query Builder Diagram (see “To remove a
table from Query Builder Diagram” on page 6-87).
Your goal for this task is to add a new philosophy class to the
database. Before you make the change, however, look at the
information for the existing courses.
1
Set Query Builder to build a SELECT statement (change the
query type to “Select.”)
2
Add table “Course” to Query Builder Diagram.
3
Click the column * (All columns) then run the SQL statement
for output to the Grid Results tab.
4
Scroll the results grid until you see the records for Philosophy.
SQL DM should show something similar to the following:
6-80