Filter
Top Products
Working with database views
84 DataWindow .NET
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, DataWindow Designer makes its best
guess as to the join columns, as follows:
• If there is a primary/foreign key relationship between the tables,
DataWindow Designer automatically joins them.
• If there are no keys, DataWindow Designer tries to join tables based on
common column names and types.
❖ To join tables:
1 Click the Join button.
2 Click the columns on which you want to join the tables.
In the following screen, the Employee and Department tables are joined on
the dept_id column: