Specifications

Working with database views
106 InfoMaker
Displaying a database
view’s SQL statement
You can display the SQL statement that defines a database view. How you do
it depends on whether you are creating a new view in the View painter or want
to look at the definition of an existing view.
❖ To display the SQL statement from the View painter:
• Select the Syntax tab in the View painter.
InfoMaker displays the SQL it is generating. The display is updated each
time you change the view.
❖ To display the SQL statement from the Database painter:
• Highlight the name of the database view in the Objects view and select
Properties from the pop-up menu, or drag the view’s icon to the Object
Details view.
The completed
SELECT statement used to create the database view
displays in the Definition field on the General page:
View dialog box is read-only
You cannot alter the view definition in the Object Details view. To alter a
view, drop it and create another view.
Joining tables
If the database view contains more than one table, you should join the tables on
their common columns. When the View painter is first opened for a database
view containing more than one table, InfoMaker makes its best guess as to the
join columns, as follows:
• If there is a primary/foreign key relationship between the tables,
InfoMaker automatically joins them.
• If there are no keys, InfoMaker tries to join tables based on common
column names and types.