|
Relating DataWindows to Databases
Setting the Transaction Object for a DataWindow Object
Retrieving Data
Coding a Complete Retrieval Transaction
The DataWindow object is associated with a database through a transaction object using the SetTransObject( ) function.
The DataWindow control Retri
|
|
|
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 Proced
|
|
|
Summary
PowerBuilder provides:
Presentation styles
Options for colors, borders, fonts, and other characteristics for columns and for column headings
You use the DataWindow painter to design the user interface.
Summary
The DataWindow workspace is divided into bands:
Header
Detail
Summary
Fo
|
|
|
Access one item by specifying row and column numbers
Format:
dwcontrol.object.data[startrownum, startcolnum]
dwcontrol.object.data [ startrownum, startcolnum, endrownum, endcolnum ]
Example:
long ll_emp_id
ll_emp_id = dw_emp.object.data[1,2]
Data retrieved using a DataWindow object is he
|
|
|
Building a Window Interface to Display Data
What Is a DataWindow Control?
DataWindow Properties and Methods
Opening a Sheet in an MDI Frame
Data stored in database
Data can be processed on any of:
Database
Middle tier
ClientTo associate a DataWindow object with a DataWindow control:
|
|
메뉴펼치기
