Home

Products

Support

Free Trial

Information

---

Home > Products > Powerbook

Powerbuilder Ebook 2006 V2

Do you need to learn more about Object Oriented Programming principles and concepts?

Do you want to learn Powerbuilder and powerscript?

Do you want to learn SQL?

Do you want a fast track to this knowlege?

Powerbook V2 covers concepts of OOP using Powerbuilder 10 as the development language. This book is suitable for both novice and intermediate level developers. It runs on the Windows platform (95 or better).

Version 2 released March 2006: See what is new in version 2

A vast collection of literature exists on these topics. However, it takes a long time to get the bits and pieces together. Powerbook offers a fast track to learing OOP principles and Powerbuilder as a development language. We explain a lot of theory and provide practical tutorials which puts theory into practice.

You will learn how to develop database applications using single document interface (SDI) and mulitple document interface (MDI) solutions. These are based on real-world applications.

To purchase this book for 19.95 USD just follow this link to a secure payment processor

To enable you to make a more informed decision, we have summarised the contents of this Powerbuilder ebook.

The parts of the book that are excluded in the trial version are rendered in red.

The full book is now available to registered members of our Joomla PHP site.

SUMMARY OF CONTENTS

Chapter 1 - An introduction to the concepts of OOP.

• Objects and Controls
• Methods - (functions and events)
• Object properties
• Encapsulation, Polymorphism, Classes and Inheritance
• Dot Notation
• The OOP Model

Chapter 2 - The Powerbuilder IDE.

• Elements of the IDE
• The Workspace
• Targets and the Application object
• The Painters (design windows)
• The System Tree
• The Clip and Output Windows
• Custom options and Hotkeys

Chapter 3 - The Window Object and Controls.

• Window object properties
• Window events and functions
• Window types
• Creating new windows
• Window arrays
• Window controls

• Practical Tutorial

Chapter 4 - The Menu Object

• Creating new menus
• Menu items
• Menu features and properties
• Menu item events
• Practical Tutorial

Chapter 5 - Creating a database

• Create a new database
• Set-up tables
• Creating an ODBC connection
• The SQLCA Object
• Coding the application open event
• Practical Example

Chapter 6 - Coding Basics

• Coments,Identifiers, Nulls, Reserved words
• Pronouns -(this, parent, super)
• Statements - Syntax, Types
• Datatypes - Standard and Enumerated
• Declarations - (Syntax, Types, Scope, Naming conventions)
• Arrays
• Scripting - Powerscript (operators, assignments, structures)
• Type conversions, Object assignments
• Powerscript statements (continue, create/destroy, exit, halt, return,throws)
• System functions (open, close,messagebox,classname, isvalid,keydown, isnull,setnull)
• Programming structures (sequence, iteration, selection)
• Powerscript structures (do..while; for..next; choose..case; if then..else)
• Practical Tutorial

Chapter 7 - Design Basics

• Encapsulation
• Inheritance
• Polymorphism
• Public Interface
• OOP Guidelines
• Library organization
• General rules and tips
  • Pronouns
  • Protected scope
  • Intance variables
  • Get and set functions
  • Inheritance
  • Non-Visual global object

Chapter 8 - The DataWindow Object

• Uses, Presentation styles
• Datawindow controls
• Special features (computed fields, attributes, sql, validation rules)
• Database connection (SetTransObject)
• Practical Tutorial

Chapter 9 - The DataWindow Painter

• Design view (header,details,sumary, groups, footer)
• Expressions
• Other views (export, properties, control list,data)
• Column specifications
• Adding controls
• Design options

Chapter 10 - Inheritance

• Benefits
• Base classes
• Inheriting a window
• Practical Tutorials

Chapter 11 - Structured Query Language (SQL)

• DML / DDL
• The Select statement - (syntax, where, order by)
• All | Distinct; Like | Matches
• The % wildcard
• Create, Insert, Update, Delete
• Commit and Rollback
• Aggregate functions (min,max,sum,avg,count)
• Combing conditions and operators
• Operators
• Table Joins
• Cursors
• Dynamic SQL
• SQL error code

Chapter 12 - Building a SDI Application

• The tables
• The windows
• The menu
• Creating window descendants
• Application open event
• Create the data objects
• Writing event script

Chapter 13 - The MDI (Multiple Document Interface)

• Sheets and the parent frame
• OpenSheet and OpenSheetWithParm statements
• Functions - (GetFirstSheet, GetNextSheet)
• Sheet arrangemets (Layered!, Cascaded!, Orginal!)
• Toolbars
• Message Object example - passing parameters
• CloseWithReturn - passing parameters
• Practical Tutorial

Chapter 14 - Creating a login window

• Response window and controls
• Create of_login function
• The inifile and profilestring option
• Script the login process
• Verifying values stores in a table with SQL statements
• Practical examples

Chapter 15 - Functions and Events

• Overview
• Built-in functions eg: Getname(), GetHelp(), Close()
• How to call functions
• User functions
• Naming conventions
• Global and Object level functions
• Arguments
• Method syntax
• Overriding, Overloading
• Extending scripts
• Events and windows messaging
• Built-in events eg: Clicked(), DoubleClicked(), Open()
• User events
• Functions vs Events

Chapter 16 - User Objects

• User Object Painter
• Classes and class declaration
• Visual and class user objects
• Standard and custom classes
• Naming conventions
• Building user objects
• Using class user objects
• A custom visual navigation object
• A custom class connection object

Chapter 17 - Building a MDI Application - part 1

• The customer database
• Tables (master, financial, transactions)
• Column Names,Data Types,Labels, Headers
• Create table, execute SQL script
• Extended attributes
• Creating additional libraries

Chapter 18 - A customer MDI - part 2

• The base maintenance window
• Specify retrieval arguments
• Set table update properties, column tab orders
• Create a non-visual customer object
• Provide get and set functions
• Create descendant windows (inheritance)
• Use of wildcard retrievals
• Provide a customer search and select
• Events (Clicked, DoubleClicked, RowFocusChanged)
• Events (Open,Constructor)
• Create a menu
• Pass parameters (OpenSheetWithParm, ReturnWithParm)
• Add a new customer
• View customer details - financial and transactions
• Display name in title bar

Chapter 19 - Building the datobjects - part 3

• Creating the customer master dataobject
• Designing retrieval arguments
• Setting update properties
• Seting tab orders

Chapter 20 - Building the application windows

• The Frame window
• The customer master window
• Coding the itemChanged event
• Get and set functions
• The customer lookup - keydown event
• Display name in title bar

Chapter 21 - Master Report Window

• Adding controls from base classes
• Setting control properties
• Creating the functions (wf_filter, wf_sort, wf_rest)
• Scripting events (Open, Clicked, SelectionChanged)

Chapter 22- Using Query Mode

• Enabling query mode
• Modify an Describe methods
• Clearing the query
• The SQLPreview event

Chapter 23- Introduction to Error Handling

• Exceptions
• Try Catch method
• The runtime error object
• Divide by zero example

Chapters 24,25,26 The Timesheet Application

• Create Table Timesheet
• The Master Application Window
• Adding controls
• The Timesheet Dataobject
• Using code tables
• Coding the functions and events
• The report dataobject
• The application windows

Chapter 27 (a)- A customer master window with added functionality

Show me this window

• The master maintenance window
• Coding the event scripts
• Itemchanged, SQLPreview
• The set buttons function
• Inheriting the master window
• Creating the DataObject
• Implementing query mode
• Implementing dynamic SQL
• Itemchanged and ItemFocusChanged Events

Chapter 27 (b) - A sales invoice window with added functionality

Show me this window

• The master post window
• The header and detail datawindows
• Get Line details function
• The set buttons function
• Inheriting the sales invoice window
• Creating the DataObjects
• Implementing query mode
• Implementing dynamic SQL
• Itemchanged and ItemFocusChanged and RowFocusChanged Events
• The print function

Chapter 28 - Deployment

• Creating a deployment object
• Deploying the application
• Required DLL files

---

The book is an executable file that will run on Windows platforms. (Windows 95 or better) and Internet Explorer 4 or better. When you download the file, select the directory where you want to save it.

To run the book, simply double-click the file.

To download the free trial version of this book now, Click Here

To register and download the full, unrestricted version of this book now,
Click Here

When you purchase this book (0nly 19.95 USD), you also receive the following:

• A free copy of our SQL Ebook
• Free upgrades to new releases of these books

To purchase and download the full, unrestricted version of this book now,
Click Here

---

Copyright © 2006-2009 RDS Online - All rights reserved

| Policies |

Feedback