|
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
|
|
|
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
|
|
|
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
|
|
|
Summary
Objects, events, and properties are key to developing applications with PowerBuilder.
Properties are characteristics of an object.
Events permit the object to recognize and respond to actions.
You can build application objects, DataWindow objects, menus, structures, user objects, and win
|
|
|
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:
|
|
|
Updating the Database
Transaction Management
Saving Data Before Closing a Window
Printing Reports Using DataWindows
Use Update( ) to save changes in a DataWindow control.
Update( ) generates SQL statements based on the contents of the primary, filter, and delete buffers.
You can control the
|
|
|
SetSort( ) defines the sorting criteria
Sort( ) performs the actual sorting
Formats:
dw_control.SetSort(sort_expression)
dw_control.Sort( )
Example:
string ls_Sequence
ls_Sequence = `dept_ID A, salary_amt D`
dw_list.SetSort(ls_Sequence)
dw_list Sort( )
At execution time, three DataWin
|
|
|
W_EMPLOYEES의 datawindow event에서
s_empinfo lstr_empinfo
w_activities lw_activities
long ll_row
ll_row = dw_data.GetRow()
lstr_empinfo.emp_id = dw_data.Object.emp_id [ll_row]
lstr_empinfo.first_name = dw_data.Object.emp_fname [ll_row]
lstr_empinfo.last_name = dw_data.Object.emp_lname [ll_row
|
|
|
Creating PowerBuilder Executable Applications
PowerBuilder Dynamic Libraries (PBDs)
PowerBuilder Resource Files (PBRs)
Using the Project Painter
Whenever resources are dynamically assigned:
DataWindows
dw_control.DataObject = `dw_object_name`
Bitmaps
picture_control.PictureName = `bmp_or_r
|
|
메뉴펼치기
