![[Book Cover]](../covergif/0135081459.gif)
More Professional PowerBuilder Programming: Advanced Techniques, 1/e
Paul Bukauskas, Redondo Beach, California
Bruce Braudstein, Los Angeles, California
Published April, 1997 by Prentice Hall PTR (ECS Professional)
Sign up for future
mailings on this subject.
See other books about:
Distributed Databases-Computer Science
This book will teach you PowerBuilder from the ground up. You'll
learn about the Painters that help you build an interface and other
elements of your application; the Help system; and the basic definitions
every PowerBuilder developer needs to understand.
covers all the basics of PowerBuilder 4.0.
includes sample PowerBuilder applications and exercises
on CD-ROM.
the least expensive PowerBuilder book/disk package for novices.
SECTION I.
1. Building on a Solid Foundation.
In This Chapter. Event-Driven Programming. Window Objects.
Window Data Types. The Window Painter. Window Properties. Accessing
Properties Using the Browser. Window Events. User-Defined Events.
Triggering Events. Posting an Event. Window Controls. Types of Windows.
MDI Frame and MDI Frame with MicroHelp. Summary. Test Yourself.
2. The Application Painter.
In This Chapter. What Is the Application Painter? Creating
an Application. Defining Application Default Settings. The Library
Search Path. Properties. Events. Summary. Test Yourself.
3. The Menu Painter.
In This Chapter. Creating a Menu. Observing Menu Conventions.
Cascading Menus. Inserting and Deleting Items. Associating a Menu
with a Window. Menu Events. Special Pronoun—ParentWindow. Observing
Menu Scripting Conventions. Special Functions. Toolbars. Dropdown
Toolbars. Displaying Popup Menus. Summary. Test Yourself.
4. The DataWindow Painter.
In This Chapter. DataWindow Objects. Launching the Painter.
Data Sources. Data Presentation Styles. Retrieval Arguments. Prompt
for Criteria. Edit Styles. Display Formats. Validation Rules. Computed
Columns. Tab Order. Groups. Retrieve Rows as Needed. Update Characteristics.
Summary. Test Yourself.
5. Data Management.
In This Chapter. Database Transactions. Elements of the
Transaction Object. What Is a Windows INI File? Changing INI File
Settings. Managing Transactions. Managing Expensive Operations. Retrieve
As Needed. Handling Different Transaction Types. TimeStamps. Summary.
Test Yourself.
6. The Database, Table, and Administration Painters.
In This Chapter. Connecting to the Database with Profiles.
Using Open Database Connectivity (ODBC). Creating Tables. Exporting
the Table Definition. Creating Indexes. Creating Primary and Foreign
Keys. Sharing Data with Other File Formats. The PowerBuilder Repository.
Specifying Format Information. Formatting Characters. Adding Color
to Formats. Display Format Masks. Edit Style. Validation. Numeric
Rules. String Rules. Writing and Executing SQL Script. Summary. Test
Yourself.
7. Library Management.
In This Chapter. Using the Library Painter. Moving and Copying
Entries. Creating and Deleting Libraries. The Proper Number of Libraries.
Library Placement. Library Size. Searching Objects. Optimizing Libraries.
Regeneration. Organizing Libraries. Naming Conventions. Source Code
Management. Version Control. Export/Import Library Entries to Text
Files. Summary. Test Yourself.
SECTION II. PROGRAMMING FOR EXCELLENCE.
8. Multiple Document Interface.
SECTION III. DATAWINDOWS.
In This Chapter. Anatomy of MDI. Frame Types. Resizing the
Frame. MDI Sheets. Managing MDI Sheets. Reusable References. Determining
the Active Sheet. Menu Support. Getting a Handle on Menus. Keeping
the Menu Synchronized. Invoking Window Actions. Displaying a Backdrop
Window. Summary. Test Yourself.
9. PowerBuilder Programming Techniques.
In This Chapter. PowerBuilder and Object-Oriented Design.
The PowerScript Language. Basic Concepts. Script Identifier Names.
Special Characters. Operators. Concatenation. Standard Data Types.
Instance and Shared Variables. Constants. Saving Compile-Time Information.
Pronouns. Arrays. Summary. Test Yourself.
10. Visual User Objects.
In This Chapter. What Are User Objects? Benefits of User
Objects. Standard Visual User Objects. A Smart Dropdown Listbox. Steps
to Create a Standard User Object. Custom Visual User Objects. External
Visual User Objects. VBX Visual User Objects. Summary. Test Yourself.
11. Nonvisual Objects by Scott McGarrigle.
In This Chapter. Split Personality. No Baggage. Bringing
Objects to Life. Referencing NVOs. Other Ways of Using Create. NVO
Events. Automatic Objects. Deep Copy. Custom Data Types. Create Using.
Building a Custom (NVO) Class. NVOs and Application Design. Application
Domains. Partitioning with NVOs. Some Examples. A Customer Business
Object. Using the Customer Object. Component-Based Architecture. The
RowSelection Component. Identifying Objects. Datastores—The Nonvisual
DataWindow. The Basic Model/View Approach. Summary. Test Yourself.
12. Drag-and-Drop Programming Techniques.
In This Chapter. What Is Drag and Drop? Drag-and-Drop Events.
The Drag Object. Properties of the Drag Object. Drag-Related Functions.
Return Values and OLE 2.0 Controls. RowsCopy and RowsMove. Have Your
Cake and Eat It Too. Dragging Rows between DataWindows. Summary. Test
Yourself.
13. Dynamic SQL.
SECTION IV. SPECIAL TOPICS.
In This Chapter. Embedding SQL. Dynamic SQL versus Static
SQL. Singleton Select. Cursor Processing. Updatable Cursors. Stored
Procedures. Executing the Procedure. DataWindows and Stored Procedures.
Dynamic SQL. Putting It All Together. Modifying the SQL Statement
of an Existing DataWindow. Summary. Test Yourself.
14. Dynamic DataWindows.
In This Chapter. Steps to Create a Dynamic DataWindow. Determining
the DataWindow Style. Preparing the SQL Statement. Creating the DataWindow.
Final Notes on Create. A Second Approach to Modifying the SQL Select.
Summary. Test Yourself.
15 Advanced DataWindow Techniques.
In This Chapter. Direct Data Manipulation. Key DataWindow
Events. SQL Preview Event. DataWindow Validation. Key DataWindow Functions.
Using Shared DataWindows. Working with External Data Sources. Checking
Database Return Codes. Checking Row and Column Status. SQL Preview.
DataStores. Summary. Test Yourself.
16. Working with Nested Reports.
In This Chapter. Nested DataWindows. Creating a Nested Report.
Sizing the Report. Using Retrieval Arguments. Previewing the DataWindow.
Sliding. Composite DataWindows. Summary. Test Yourself.
17. Child DataWindow TechniqueS.
In This Chapter. Steps to Use a Dropdown DataWindow. GetChild.
Retrieval Arguments. Other DataWindow Techniques. Shared Result Sets.
Summary. Test Yourself.
18. Windows API by David Litwalk.
SECTION V. DATE MODELING FOR CLINET/SERVER APPLICATIONS.
In This Chapter. Windows: A Developer's Perspective Windows
Employs a Graphical User Interface. Windows Is a Message Broker. Windows
Is a Multitasking Environment. Windows Supports Dynamic Libraries.
Summary. Test Yourself.
19. Communicating between Objects by Scott McGarrigle.
In This Chapter. The Communication Process. Aspects of Object
Communication. Object Communication Design Principles. The Message
Object. Events and Functions. Events. Posting Events. Communication
Models. Nonresponse Window Return Model. Communication Parameters.
Communication Targets. Advanced Communication Ideas. Advanced Message
Object. Summary. Test Yourself.
20. The Mysteries of Describe and Modify.
In This Chapter. Describe. Modify. Expressions in the DataWindow
Painter. Summary. Test Yourself.
21. Performance and Tuning.
In This Chapter. Redraw When Necessary. Use the Open Event.
Limit Data or Post. Using Arrays. Pass Values by Reference. Memory
Leaks. Working with Loops and Control Structures. General Use of Functions.
Summary. Test Yourself.
22. Moving Data Using Pipelines.
In This Chapter. Creating a Pipeline Object. Table Options.
Pipeline Execution. Pipeline Attributes. Functions. Data Pipeline
Events. Pipeline Automation. Summary. Test Yourself.
23. DDE and OLE.
In This Chapter. Dynamic Data Exchange (DDE). Object Linking
and Embedding. Summary. Test Yourself.
24. Creating the EXECUTABLE.
In This Chapter. The Project Painter. Creating Dynamic Libraries.
P-Code Distribution Options. Objects Included at Runtime. Objects
Not Included at Runtime. PowerBuilder Resource Files (PBRs). Object
Management. Summary. Test Yourself.
25. EHLLAPI Application Programming, by Thomas O'Mara.
In This Chapter. Overview. EHLLAPI Application. EHLLAPI
Services. EHLLAPI Connections. EHLLAPI Presentation Spaces. EHLLAPI
Function Calls. EHLLAPI Prerequisite Function Calls. EHLLAPI Return
Codes. EHLLAPI Keyboard Mnemonics. NetSoft Elite/400 Emulation Session.
Wall Data Rumba Emulator Session. PowerBuilder Application with the
EHLLAPI. Summary. Test Yourself.
26. Data Modeling—An Overview, by Ted Kerr.
VI. APPENDIXES.
In This Chapter. Abstracting Business Data. Problem Summary.
Criteria for Database Design. Tools and Mechanisms. Summary.
27. Modeling Data Entities, by Ted Kerr.
In This Chapter. Facts and Entities. Identifying Entities.
Entering Entities into a Model. Entity Name and Definition. Attributes.
Types of Attributes. Relationships between Entities. Business Rules.
Summary.
28. Database Maintenance and Integrity, by Ted Kerr.
In This Chapter. Generating a Physical Database. Selecting
a Target Database. Defining Physical Schema Information. Defining
Domains. Synchronizing ERwin to a Target Database. Database Integrity.
Insert Operations. Delete Operation. Generating the Schema. ERwin
as a Database Schema Manager. ERwin as an External Schema Manager.
Synchronizing with PowerBuilder. Generalize Extended Attributes into
Domains. ERwin as the Central Repository. Summary.
Appendix A. Answers to Test Yourself Questions.
Appendix B. Preparing for the Certified PowerBuilder Developer
(CPD) Exam.
Appendix C. Practical Exercises.
Appendix D. What's on the CD.
Index.
![[Help]](../images/cat_help.gif)
© Prentice-Hall, Inc. A Simon & Schuster Company
Comments To webmaster@prenhall.com