Filter
Top Products
CHAPTER 4 Defining DataWindow Objects
DataWindow Designer User’s Guide 123
Below the Table Layout view, several tabbed views also display by default.
You use the views (for example, Compute, Having, Group) to specify the SQL
Select statement in more detail. You can turn the views on and off from the
View menu on the menu bar.
Specifying what is
displayed
You can display the label and datatype of each column in the tables (the label
information comes from the extended attribute system tables). If you need
more space, you can choose to hide this information.
❖ To hide or display comments, datatypes, and labels:
1 Position the pointer on any unused area of the Table Layout view and
select Show from the pop-up menu.
A cascading menu displays.
2 Select or clear Datatypes, Labels, or Comments as needed.
Colors in the Select
painter
The colors used by the Select painter to display the Table Layout view
background and table information are specified in the Database painter. You
can also set colors for the text and background components in the table header
and detail areas.
For more information about specifying colors in the Database painter, see
“Modifying database preferences” on page 58.
Adding and removing
tables and views
You can add tables and views to your Table Layout view at any time.
Table 4-3: Adding tables and views in the Select painter
You can also remove individual tables and views from the Table Layout view,
or clear them all at once and begin selecting a new set of tables.
How DataWindow
Designer joins tables
If you select more than one table in the Select painter, DataWindow Designer
joins columns based on their key relationship.
For information about joins, see “Joining tables” on page 126.
To do this Do this
Add tables or views Click the Tables button in the PainterBar and select
tables or views to add
Remove a table or view Display its pop-up menu and select Close
Remove all tables and views Select Design>Undo All from the menu bar