Oracle Developer/2000 Forms

Want to read this on your NOOK? Request as NOOK Book from the publisher

Thank you for requesting this book as a NOOK book from the publisher.

More About This Book

Overview
Editorial Reviews
Product Details
Related Subjects
Read an Excerpt
Table of Contents
Preface

Overview

The first section of the book explains the key concepts and tools used by Forms-a perfect introduction for end users or new developers, and a great reference and review of new features in 5.0. Intermediate programmers will zoom in on the second and third sections, with their comprehensive coverage of Forms applications at work. Advanced developers can make the most of the final chapters, which show how to integrate Forms modules with other tools in the Developer/2000 suite, and with other technologies such as Java and Active X.

Oracle Developer/2000 Forms: The Practitioner's Guide's thorough and detailed treatment includes:

Basics: The Form Builder and Runtime environments
Tools: Navigation, editing, libraries, and PS/SQL
Objects, Events, and Triggers: Data blocks, items, windows, and record structures
Advanced Oracle Programming: Using Forms with Report Builder, Graphic Builder, and Project Builder
Integrated Windows Programming: Combining Forms with MS applications via DDE, OLE, and ActiveX

Follow this complete reference guide to build the most sophisticated Oracle database for client-server and Internet applications.

The software accompanying Oracle Developer/2000 Forms: The Practitioner's Guide includes dozens of applications and examples that allow you to implement the skills from each chapter with immediate hands-on activities. In addition to the sample applications, you can view Lotus ScreenCam® movies showing the most important actions you will encounter in each form. The CD includes ScreenCam Player software for Windows® 95 and Windows NT,and the CBT software for Developer/2000 Forms: Fundamentals.

Read More Show Less

Editorial Reviews

Booknews

Brings together the material needed to get Forms applications up and running fast. Covers key concepts and tools, Forms applications at work, and how to integrate Forms modules with other tools in the Developer/2000 suite and with other technologies such as Java and ActiveX. Topics include the Form Builder and Runtime environments; navigation, editing, libraries, and PS/SQL; data blocks, items, windows, and record structures; using forms with Report, Graphic, and Project Builder; and combining forms with MS applications via DDE, OLE, and ActiveX. The accompanying CD-ROM includes dozens of applications and examples. Annotation c. by Book News, Inc., Portland, Or.

Read More Show Less

Product Details

ISBN-13: 9780139490330
Publisher: Pearson Education
Publication date: 11/9/1998
Series: Prentice Hall Oracle Series
Edition description: BK&CD-ROM
Edition number: 1
Pages: 1000
Product dimensions: 7.06 (w) x 9.24 (h) x 2.72 (d)

Read an Excerpt

PREFACE: Preface

Developer/2000 Forms is the most important tool used to create client/server and World Wide Web applications that run against Oracle databases. Developer/2000 Forms: The Practitioner's Guide is a complete reference guide for those who use Forms to build sophisticated database systems rapidly and productively. The book covers in detail all the aspects, features and functionality of Developer/2000 Forms. It also focuses on how modern application development concepts, such as client/server computing and object-oriented programming, are applied in the Developer/2000 Forms environment.

Organization of the Book

Developer/2000 Forms: The Practitioner's Guide is divided in five parts. They can be read sequentially or independently, depending on the your familiarity with Developer/2000 Forms. The following paragraphs describe these parts:

Part One. This part introduces readers to Developer/2000 Forms programming. Following the detailed instructions provided in this part, you build and run your first form. In the process, I present important concepts of Form Builder and Runtime environments. At the end of this part, you will have completed the first form and become familiar with terms and concepts that will be encountered throughout the rest of the book.

Part Two. This part equips you with the necessary tools to create, design and enhance forms. It begins with an overview of Developer/2000 and then focuses on the Form Builder and its components: Object Navigator, Layout Editor, Property Palette, Menu Editor, Object Library Editor and PL/SQL Editor. Separate chaptersdiscuss the purpose, access methods, components and usage of each tool. Rapid Application Development (RAD) and object reusability with Developer/2000 Forms are also covered in this part. The final three chapters discuss the elements of the Standard Query Language (SQL) used in Oracle applications, the Oracle's own programming language-PL/SQ-as well as object-relational features introduced by Oracle8 that affect Developer/2000 Forms programming.

Part Three. This part presents the Form Builder as an object-oriented and event-driven programming environment. It explains the features and functionality of its objects, including data blocks, items, windows, record structures and menus. It also discusses events associated with each object, triggers they fire, and how you can use them to enhance Forms applications.

Part Four. This part covers advanced programming with Developer/2000 Forms. It begins with debugging techniques and activities. Then, it discusses the integration of Forms with other Developer/2000 tools, such as Report Builder and Graphic Builder. I dedicate an entire chapter to the reusable components provided by Developer/2000 and the benefits you draw by including them in your applications. Another important subject I cover in this part is the development and deployment of Forms applications on the Web in a three-tier architecture. In a separate chapter, I present tips and techniques to simplify Forms development and installation using the Developer/2000 Project Builder. I conclude this part discussing the use of Designer/2000 in creating, maintaining and generating Form Builder modules.

Part Five. This part focuses on to the integration of Developer/2000 Forms with other Microsoft Windows applications through Dynamic Data Exchange (DDE), and Microsoft's COM-based technologies, including OLE Documents, Automation, and Activex controls. I also cover here the implementation of user exits and the extension of Developer/2000 applications' functionality using the PL/SQL interface to foreign functions.

Audience

Developer/2000 Forms: The Practitioner's Guide is intended primarily for software engineers whose mission is to create database applications for the Oracle DBMS. As such, this book addresses the needs of this group of IT professionals. Because of the way the material is organized, the book can be used by application developers at all levels of proficiency.

The first part is for newcomers to the Developer/2000 Forms environment. This part explains important Form Builder and Runtime concepts which benefit not just the beginner, but also end-users of Oracle applications.

The second part addresses the needs of intermediate programmers who do not have a vast experience with Developer/2000 Forms. The chapters in this part are organized to serve as reference materials for the main components of the Form Builder, where most of the development activities occur.

The third part explains fundamental concepts that every serious Developer/2000 Forms developer should know and master. The material covered in this part is for programmers dedicated to creating applications conforming with object-oriented principles, Multiple-Document Interface (MDI) paradigm and well-established GUI principles.

The last two parts of the book provide information for advanced programmers who go the extra mile to deliver integrated and user-friendly applications. The focus in Part Four is the integration of Developer/2000 Forms modules with others Oracle design and development tools-Designer/2000, Developer/2000 tools, and Developer/2000 reusable components. Part Five targets developers familiar with Microsoft Windows programming techniques and shows them how to integrate them in the Form Builder environment.

Here is a list of the most important benefits this book offers to you:

Clear and concise explanation of all the features of Developer/2000 Forms.

Presentation of important aspects of Developer/2000 Forms programming in the context of building Oracle-based enterprise applications.

Gradual introduction of concepts and techniques that allows readers to build on their existing knowledge and increase their Developer/2000 Forms proficiency level.

Detailed instructions on how to perform the major development activities in Developer/2000 Forms.

A number of hands-on activities that allow readers to apply the concepts discussed in the book.

A companion CD-ROM that contains all the software modules discussed in the book. The software provides readers with a chance to execute these modules and explore for themselves the code segments that implement the features discussed in the book.

The Companion CD-ROM

Developer/2000 Forms: The Practitioner's Guide is first and foremost a hands-on guide to application development with Developer/2000 Forms, and you should read it as such. I strongly urge you to follow the discussion of different topics in the book by performing the activities with one or more application systems in your environment. In order to help you with these activities, I have provided a CD-ROM that contains a number of application systems that you use, as well as Lotus ScreenCam ª movies you can play. These software assets are very important because they allow the you to start from any chapter in the book and follow the hands-on activities discussed in that chapter. They also serve as reference items that can be used to explore the implementation of the features discussed in the book. Developer/2000 version 2.1 was used to produce the application systems and record the movies. I discuss the contents of the CD-ROM in the following two sections. The last page in the book shows you how to use the CD-ROM.

Software

To help you understand the topics discussed in Developer/2000 Forms: The Practitioner's Guide, the companion CD-ROM contains sample applications discussed throughout the book. The intention of the provided software is to allow you to perform in your environment the most important activities discussed in the book. This software is organized by application systems covered in the book. A list of these applications follows:

Equipment Tracking System application. This is the application discussed in Chapters 1, 2, and 3.

Movie Rental Database objects 1. These are tables you can use to test the SQL statements discussed in Part Two.

MRD application. This is the application system developed throughout Part 3 and, partly, in Part 4.

Form Builder modules integrated with Developer/2000 reusable components. These are the modules discussed in chapter 22 in which I have integrated Developer/2000 reusable controls, such as a calendar, hierarchy navigator, wizard dialog box, and so on to your Forms applications.

Form Builder modules implementing DDE. These are the modules discussed in chapter 26 that allow you to integrate Form Builder with Microsoft Excel, Word and Program Manager through Dynamic Data Exchange.

Form Builder modules implementing COM-based technologies. These are the modules discussed in chapters 27 and 28 implement OLE documents, Automation, and Activex controls in the Form Builder environment.

Lotus ScreenCam Movies

To help you understand the topics discussed in Developer/2000 Forms: The Practitioner's Guide, I provide the most important actions you will encounter in the form of Lotus ScreenCam movies. You will find over xxx of these movies for a total duration of over yyy hours. To help you access them more easily, the movies are organized by parts and chapters of the book. The movies provided on the CD-ROM are not recorded with sound. However, a script describes the most important activities that occur during the movie.

In order to view the movies, you need to download from the CD-ROM the ScreenCam Player application and store it in a folder on your PC. Versions of ScreenCam Player for Windows95 and for Windows NT are available. You need to use the one that matches your environment. For the latest version of the ScreenCam Player application, visit the Web site of Lotus Corporation at ...

Read More Show Less

	List of Figures
	Preface
Pt. I	Introduction to Developer/2000 Forms	1
1	Developing the First Form	3
2	Running the First Form	29
3	Enhancing the First Form	49
Pt. II	Forms Developer Toolbox	77
4	Developer/2000 Form Builder	79
5	Object Navigator	103
6	Layout Editor	127
7	Property Palette, Menu Editor, and Library Editor	175
8	RAD and Object Reusability	201
9	Introduction to SQL	225
10	Introduction to PL/SQL	269
11	Object-Relational Oracle8 and PL/SQL8	319
Pt. III	Developer/2000 Forms Objects	345
12	Object-Oriented Analysis and Design	347
13	Data Blocks, Frames, and Relations	369
14	Items and Data Items	409
15	GUI Control Items	445
16	Windows, Canvases, and Dialog Boxes	473
17	Record Structures and Other Objects	515
18	Menus and Toolbars	555
19	PL/SQL Objects	581
Pt. IV	Building Integrated Developer/2000 Applications	615
20	Debugging	617
21	Creating Integrated Developer/2000 Applications	637
22	Developer/2000 Reusable Components	671
23	Managing Developer/2000 Projects	691
24	Developer/2000 Forms for the Web	719
25	Creating Forms with Designer/2000	745
26	Generating Designer/2000 Modules	785
Pt. V	Extending Developer/2000 Applications with Microsoft Technologies	813
27	Dynamic Data Exchange	815
28	COM-Based Technologies	845
29	Automation and ActiveX Controls	877
30	Foreign Function Interface	907
	Index	943
	About the CD-Rom	953

Read More Show Less

Preface

PREFACE: Preface

Developer/2000 Forms is the most important tool used to create client/server and World Wide Web applications that run against Oracle databases. Developer/2000 Forms: The Practitioner's Guide is a complete reference guide for those who use Forms to build sophisticated database systems rapidly and productively. The book covers in detail all the aspects, features and functionality of Developer/2000 Forms. It also focuses on how modern application development concepts, such as client/server computing and object-oriented programming, are applied in the Developer/2000 Forms environment.

Organization of the Book

Developer/2000 Forms: The Practitioner's Guide is divided in five parts. They can be read sequentially or independently, depending on the your familiarity with Developer/2000 Forms. The following paragraphs describe these parts:

Part One. This part introduces readers to Developer/2000 Forms programming. Following the detailed instructions provided in this part, you build and run your first form. In the process, I present important concepts of Form Builder and Runtime environments. At the end of this part, you will have completed the first form and become familiar with terms and concepts that will be encountered throughout the rest of the book.

Part Two. This part equips you with the necessary tools to create, design and enhance forms. It begins with an overview of Developer/2000 and then focuses on the Form Builder and its components: Object Navigator, Layout Editor, Property Palette, Menu Editor, Object Library Editor and PL/SQL Editor. Separatechaptersdiscuss the purpose, access methods, components and usage of each tool. Rapid Application Development (RAD) and object reusability with Developer/2000 Forms are also covered in this part. The final three chapters discuss the elements of the Standard Query Language (SQL) used in Oracle applications, the Oracle's own programming language-PL/SQ-as well as object-relational features introduced by Oracle8 that affect Developer/2000 Forms programming.

Part Three. This part presents the Form Builder as an object-oriented and event-driven programming environment. It explains the features and functionality of its objects, including data blocks, items, windows, record structures and menus. It also discusses events associated with each object, triggers they fire, and how you can use them to enhance Forms applications.

Part Four. This part covers advanced programming with Developer/2000 Forms. It begins with debugging techniques and activities. Then, it discusses the integration of Forms with other Developer/2000 tools, such as Report Builder and Graphic Builder. I dedicate an entire chapter to the reusable components provided by Developer/2000 and the benefits you draw by including them in your applications. Another important subject I cover in this part is the development and deployment of Forms applications on the Web in a three-tier architecture. In a separate chapter, I present tips and techniques to simplify Forms development and installation using the Developer/2000 Project Builder. I conclude this part discussing the use of Designer/2000 in creating, maintaining and generating Form Builder modules.

Part Five. This part focuses on to the integration of Developer/2000 Forms with other Microsoft Windows applications through Dynamic Data Exchange (DDE), and Microsoft's COM-based technologies, including OLE Documents, Automation, and Activex controls. I also cover here the implementation of user exits and the extension of Developer/2000 applications' functionality using the PL/SQL interface to foreign functions.

Audience

Developer/2000 Forms: The Practitioner's Guide is intended primarily for software engineers whose mission is to create database applications for the Oracle DBMS. As such, this book addresses the needs of this group of IT professionals. Because of the way the material is organized, the book can be used by application developers at all levels of proficiency.

The first part is for newcomers to the Developer/2000 Forms environment. This part explains important Form Builder and Runtime concepts which benefit not just the beginner, but also end-users of Oracle applications.

The second part addresses the needs of intermediate programmers who do not have a vast experience with Developer/2000 Forms. The chapters in this part are organized to serve as reference materials for the main components of the Form Builder, where most of the development activities occur.

The third part explains fundamental concepts that every serious Developer/2000 Forms developer should know and master. The material covered in this part is for programmers dedicated to creating applications conforming with object-oriented principles, Multiple-Document Interface (MDI) paradigm and well-established GUI principles.

The last two parts of the book provide information for advanced programmers who go the extra mile to deliver integrated and user-friendly applications. The focus in Part Four is the integration of Developer/2000 Forms modules with others Oracle design and development tools-Designer/2000, Developer/2000 tools, and Developer/2000 reusable components. Part Five targets developers familiar with Microsoft Windows programming techniques and shows them how to integrate them in the Form Builder environment.

Here is a list of the most important benefits this book offers to you:

Clear and concise explanation of all the features of Developer/2000 Forms.

Presentation of important aspects of Developer/2000 Forms programming in the context of building Oracle-based enterprise applications.

Gradual introduction of concepts and techniques that allows readers to build on their existing knowledge and increase their Developer/2000 Forms proficiency level.

Detailed instructions on how to perform the major development activities in Developer/2000 Forms.

A number of hands-on activities that allow readers to apply the concepts discussed in the book.

A companion CD-ROM that contains all the software modules discussed in the book. The software provides readers with a chance to execute these modules and explore for themselves the code segments that implement the features discussed in the book.

The Companion CD-ROM

Developer/2000 Forms: The Practitioner's Guide is first and foremost a hands-on guide to application development with Developer/2000 Forms, and you should read it as such. I strongly urge you to follow the discussion of different topics in the book by performing the activities with one or more application systems in your environment. In order to help you with these activities, I have provided a CD-ROM that contains a number of application systems that you use, as well as Lotus ScreenCam ª movies you can play. These software assets are very important because they allow the you to start from any chapter in the book and follow the hands-on activities discussed in that chapter. They also serve as reference items that can be used to explore the implementation of the features discussed in the book. Developer/2000 version 2.1 was used to produce the application systems and record the movies. I discuss the contents of the CD-ROM in the following two sections. The last page in the book shows you how to use the CD-ROM.

Software

To help you understand the topics discussed in Developer/2000 Forms: The Practitioner's Guide, the companion CD-ROM contains sample applications discussed throughout the book. The intention of the provided software is to allow you to perform in your environment the most important activities discussed in the book. This software is organized by application systems covered in the book. A list of these applications follows:

Equipment Tracking System application. This is the application discussed in Chapters 1, 2, and 3.

Movie Rental Database objects 1. These are tables you can use to test the SQL statements discussed in Part Two.

MRD application. This is the application system developed throughout Part 3 and, partly, in Part 4.

Form Builder modules integrated with Developer/2000 reusable components. These are the modules discussed in chapter 22 in which I have integrated Developer/2000 reusable controls, such as a calendar, hierarchy navigator, wizard dialog box, and so on to your Forms applications.

Form Builder modules implementing DDE. These are the modules discussed in chapter 26 that allow you to integrate Form Builder with Microsoft Excel, Word and Program Manager through Dynamic Data Exchange.

Form Builder modules implementing COM-based technologies. These are the modules discussed in chapters 27 and 28 implement OLE documents, Automation, and Activex controls in the Form Builder environment.

Lotus ScreenCam Movies

To help you understand the topics discussed in Developer/2000 Forms: The Practitioner's Guide, I provide the most important actions you will encounter in the form of Lotus ScreenCam movies. You will find over xxx of these movies for a total duration of over yyy hours. To help you access them more easily, the movies are organized by parts and chapters of the book. The movies provided on the CD-ROM are not recorded with sound. However, a script describes the most important activities that occur during the movie.

In order to view the movies, you need to download from the CD-ROM the ScreenCam Player application and store it in a folder on your PC. Versions of ScreenCam Player for Windows95 and for Windows NT are available. You need to use the one that matches your environment. For the latest version of the ScreenCam Player application, visit the Web site of Lotus Corporation at ...

Read More Show Less

Customer Reviews

Be the first to write a review

( 0 )

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

If you find inappropriate content, please report it to Barnes & Noble

Oracle Developer/2000 Forms

Overview

More About This Book

Overview

Editorial Reviews

Booknews

Product Details

Related Subjects

Read an Excerpt

Table of Contents

Preface

Customer Reviews

5 Star

4 Star

3 Star

2 Star

1 Star