파워빌더 교안 7

목차

*Overview of DataWindow Objects

*Creating a DataWindow Object

*Data Sources

*Using the Quick Select Data Source

*The SQL Painter

*Previewing a DataWindow Object

*Saving a DataWindow Object

본문내용

Creating a DataWindow Object
1. Choose a presentation style
2. Choose a datasource
3. Describe the result set
4. Design the format for data presentation and validation
5. Use simultaneous preview during design, if desired
Data sources
Relational
Quick Select
SQL Select
Query
Stored Procedure
Nonrelational
External
SQL Toolbox
Tabs on SQL Toolbox:
Sort
Where
Group
Having
Compute
Syntax
SQL Toolbox
Tabs on SQL Toolbox:
Sort
Where
Group
Having
Compute
Syntax
Individual Exercise
Begin building a DataWindow object using these steps:
Presentation: Tabular
Datasource: SQL Select
Tables:
product
sales_order_items
Now stop
Are the tables joined correctly?
Try to change the join
Exit the DataWindow painter without saving

키워드

파워빌더,   교안,   Objects,   DataWindow,   Data Sources