2012

For example, you can find all records from the current database table where
the value of the "room type" field equals "office."
■ Range Query. Provides an environment where you can develop a query
that returns all records that fall within a given range of values. For example,
you can find all records from the current database table where the value
of the "room area" field is greater than or equal to 90 square feet and less
than or equal to 120 square feet.
■ Query Builder. Provides an environment where you can develop more
complicated queries based on multiple search criteria. For example, you
can find all records from the current database table where the "room type"
equals "cubicle" and room area is greater than 80 square feet.
■ SQL Query. Provides an environment where you can develop sophisticated
queries that conform with the SQL 92 protocol. For example, you can select
* from california.headquarters.room where
california.headquarters.room.type = 'cubicle'
and
california.headquarters.room.area < 80.
See
Construct Simple Queries on page 2034 for detailed information about
constructing queries and working with operators. If you are already comfortable
building database queries, see Use the Query Builder on page 2037.
To open the Query Editor
1 Click Toolsmenu ➤ Palettes ➤ DbConnect.
2 In the dbConnect Manager, in the tree view, select a database table.
3 Click the New Query button.
4 In the New Query dialog box, enter a name for the query in New Query
Name.
5 Click Continue to open the Query Editor.
Quick Reference
Commands
DBCONNECT
Provides an interface to external database tables.
Overview of Queries | 2033