Mastering Oracle Power Objects

by Greenwald, Rick; Hoskin, Robert E.

• ISBN13: 9781565922396
• ISBN10: 1565922395
• Edition: Disk
• Format: Paperback
• Copyright: 1997-03-01
• Publisher: Oreilly & Associates Inc

Summary

The first book to cover Power Objects Version 2, a cross-platform development tool that greatly simplifies the development of client/server database applications. Aimed at developers, it provides in-depth coverage of advanced features, including lists, reports, built-in methods, object-oriented principles, global functions and messaging, and use of PL/SQL and the World Wide Web. The accompanying disk contains practical and complete examples that will help you build working applications, right now.

Table of Contents

Preface	xi
I: Overview	1	(32)
1. Introducing Oracle Power Objects	3	(32)
The Challenges of Client/Server Computing	3	(2)
What is Oracle Power Objects?	5	(4)
OPO Fundamentals	9	(9)
Oracle Basic	18	(9)
The Version 2 Developer Interface	27	(5)
The Order Entry System	32	(1)
II. OPO and Data	33	(150)
2. Client-Side Data Issues	35	(36)
Using Data in a Client/Server System	36	(1)
Binding Data in Oracle Power Objects	37	(7)
Counter Objects	44	(3)
Master-Detail Relationships	47	(7)
Recordsets	54	(2)
Recordset Methods	56	(7)
Shared Recordsets	63	(1)
Standalone Recordsets	63	(1)
Fetch Modes	64	(7)
3. Server-Side Data Issues	71	(44)
Sessions	72	(11)
Transactions	83	(6)
Transactions and Locking	89	(5)
Transactions and RowFetchMode	94	(3)
Handling Lost Updates	97	(11)
EXEC SQL	108	(7)
4. Moving Data	115	(68)
Migrating Databases with the Migration Tool	116	(5)
Moving Data with Drag and Drop	121	(4)
Exporting Selected Rows	125	(15)
Importing Data From a File	140	(6)
Handling Import Errors	146	(5)
Delivering Feedback	151	(8)
Enhancing the Import Process	159	(24)
III: Global Issues	183	(108)
5. Built-In Methods	185	(32)
Open Form Example	186	(9)
Update and Insert Example	195	(22)
6. Global Variables, Functions, and Menus	217	(32)
Basic Variable Scoping	217	(6)
User-Defined Properties and Methods	223	(4)
Communicating with Methods	227	(4)
Implementing Menus, Toolbars, and Status Lines	231	(18)
7. Object Classes and Libraries	249	(42)
Libraries	250	(5)
Classes	255	(18)
Subclasses	273	(18)
IV: Creating Real Applications	291	(122)
8. Lists	293	(52)
List Boxes	294	(4)
Version 2--The New CSList Object	298	(8)
List Box Classes	306	(9)
Pick Lists	315	(8)
Creating a Quantity Form	323	(22)
9. Reports	345	(24)
Version 2 Reporting Tool Options	346	(1)
Using Views in OPO Reports	347	(2)
Constructing a Report with the OPO Report Writer	349	(7)
Coordinating Your Report with a QBF Form	356	(4)
Reporting with Crystal Reports Pro v5.0	360	(9)
10. Implementing Drag and Drop	369	(20)
Drag and Drop Architecture	369	(1)
Mouse Methods	370	(2)
Of Mice and Clicks	372	(1)
Dropping over Fixed Objects	373	(1)
Dropping over Repeaters	374	(1)
Using Drag and Drop	374	(15)
11. Compiling and Debugging Applications	389	(24)
Compiling Applications	390	(2)
Deployment Options	392	(3)
Finding Errors	395	(11)
Trapping Run-Time Database Errors	406	(3)
Designing for Error-Free Operation	409	(4)
V: OPO and Beyond	413	(42)
12. PL/SQL	415	(18)
Why PL/SQL?	415	(2)
What is PL/SQL?	417	(1)
PL/SQL Syntax	417	(2)
The Structure of a PL/SQL Program	419	(4)
Packages	423	(1)
OPO and PL/SQL Procedures	424	(9)
13. Integrating the Web	433	(22)
All You Need to Know About the Internet	434	(2)
Accessing the Web Through Power Objects	436	(13)
OPO in the Web	449	(4)
Summing Up	453	(2)
Appendix: OPO Questions and Answers	455	(18)
Index	473