PowerBuilder Online Courses

Advanced PowerBuilder 7

• MDI Applications
• Review of Course - I
• Introduction
• MDI Concepts
• MDI Basics
• Frame
• Client Area
• Sheets
• MDI_1 Control
• Moving Sheets
• Converting to a MDI Application
• Opening an Instance of a Window
• Creating a New User Interface
• Resizing the Controls Automatically
• Arranging Sheets
• Displaying About Window
• Displaying a Background Logo
• Minimizing Application When Idle
• Customizing Toolbars
• Scoping Variables
• Local Variables
• Global Variables
• Shared Variables
• Instance Variables
• Communication between Objects
• Global Variables
• Referencing Window Variables Directly
• Opening Window with a Parameter
• Structures
• The Message Object
• Calling Functions
• Triggering or Posting Events
• Displaying Popup Menu on the DataWindow
• Summary
• Review Questions & Answers
• Exercises
• Advanced DataWindows – Part I
• DataWindow Buffers
• Adding Rows
• Deleting Rows
• Filtering Rows
• Modifying Rows
• Edit Control Buffer in the DataWindow Control
• DataWindow - Data Validation
• DataWindow Events
• RetrieveStart Event
• RetrieveRow Event
• RetrieveEnd Event
• PrintStart Event
• PrintPage Event
• PrintEnd Event
• UpdateStart Event
• UpdateEnd Event
• EditChanged Event
• ItemChanged Event
• ItemError Event
• ItemFocusChanged Event
• DbError Event
• Error Event
• SQLPreview Event
• Other Non-Mapped, but Important DataWindow Events
• Removing Unwanted Rows
• Data Retrieval Cancellation
• Appending the New Result Set to the DataWindow
• Appending a Row Automatically
• TAB Key Behavior to the ENTER Key in a DataWindow
• Resetting Update Status of All Rows
• Powering up the UP Arrow Key in the DataWindow
• DataWindow Update Properties
• Multiple Table DataWindow Update
• Parent-Child Tables Data-Entry
• INSERT Trigger On trans Table
• DELETE Trigger On trans Table
• UPDATE Trigger On trans Table
• An Introduction to Triggers
• DropDown/Child DataWindows
• Modifying DDDW Dynamically
• Dynamic DataWindows
• DataWindow Object—Dynamic Assignment
• Modifying Data Source Definitions
• GetSqlPreview() & SetSqlPreview()
• GetSQLSelect() and SetSQLSelect()
• Modify() Function
• The DW Syntax Tool
• On Fly DataWindow Creation
• Summary
• Review Questions & Answers
• Exercises:
• Object Orientation—PB Implementation
• In This Session You Will Learn:
• What Are Objects?
• Objects Basics
• Class
• Instances
• Abstract Class
• Concrete Class
• Messages
• Methods
• SubClass
• SuperClass
• Inheritance
• Base Classes
• Inheriting the Code
• Inheriting the Interface
• Multiple Inheritance
• Benefits of Inheritance
• Encapsulation
• Benefits of Encapsulation
• Polymorphism
• Overloading
• Inclusional Polymorphism OR Overriding
• Operational Polymorphism
• Delegation - Aggregate Relationship
• Inheritance in PowerBuilder
• Inheriting a Window
• Scripts
• Viewing Ancestor Script
• Extending Ancestor Script
• Overriding Ancestor Script
• Calling Ancestor Scripts
• Inheriting Menu Objects
• Multiple Inheritance
• Encapsulation in PowerBuilder
• Variables & Scoping
• Name Spaces
• Access Levels - Variables
• Access Levels - Functions
• Choosing Between Events and Functions
• Creating an Instance
• Destroying an Instance
• Garbage Collection
• Polymorphism in PowerBuilder
• Sending Messages
• Function Overloading
• Function Overloading Using Inheritance
• Function Overloading Without Using Inheritance
• Function Overriding
• PowerBuilder's Class Hierarchy
• The Object Browser
• Summary
• User Objects
• Introduction
• Visual User Objects
• Class (Non-Visual User Objects)
• Creating a Standard User Object
• Creating a CommandButton User Object
• Creating a DataWindow User Object
• Context Sensitive Help For DataWindow Controls
• Custom User Objects
• Painting the Custom User Object
• Creating Functions For the Custom User Object
• Global Function f_copyrecord
• User Object Level Function uf_initialize
• Code For The DataWindow Control
• Code For the CommandButton
• External User Objects
• Standard Class
• Custom Class
• Notes on User Object Programming
• User Objects On Windows
• Resizing User Objects
• Time Related Existence
• Placing Non-Visual User Objects
• PARENT and THIS Pronouns
• User Object Events
• Summary
• Exercises
• Embedded & Dynamic SQL
• Introduction
• Embedded SQL - PowerBuilder Implementation
• Using Host Variables
• SELECT INTO
• The UPDATE Statement
• The INSERT Statement
• The DELETE Statement
• Cursors
• Declaring And Executing a Cursor
• Creating a Cursor
• Executing the Cursor
• Isolation Levels
• Dirty Reads
• Non-Repeatable Reads
• Phantom Rows
• The FETCH Statement
• Cursors and Transaction Objects
• Scrollable Cursors
• Updating Through a Cursor
• Deleting Through a Cursor
• Stored Procedures
• SQL Anywhere Stored Procedures
• SQL Server Stored Procedures
• Using a Stored Procedure In PowerScript
• Declaring a Stored Procedure
• Executing a Stored Procedure
• Executing a Remote Stored Procedure
• Retrieving Multiple Result Sets
• Retrieving the Value Of OUTPUT Variable
• Dynamic SQL
• Dynamic Staging Area
• Dynamic Description Area
• Format 1
• Format 2
• Format 3
• Format 4
• Handling the Results
• Summary
• External Functions
• Introduction
• Declaring External Functions
• Datatypes For External Function Arguments
• External Function Arguments
• Calling an External Function
• Calling an External Subroutine
• Multimedia and PowerBuilder
• Frequently Used MS-Windows APIs
• Copying the Specified File
• Finding the Current Directory
• Setting the Current Directory
• Creating a Directory
• Finding the Computer Name
• Setting the Computer Name
• Reading the Value of an Environment Variable
• Finding the Volume Information
• Writing to the Windows NT Event Log
• Displaying a URL in the Default Browser
• Finding the System Directory
• Finding Where the EXE is Running From
• Copying the Active Window to the Clipboard
• Copying the Full Screen to the Clipboard
• Browse For the Folder
• Closing the Current Session And Display Login Screen
• Call-Back External Functions
• Stored Procedures - External Functions
• Cross Platform Issues
• Summary
• Debugging, Tracing & Profiling
• Running Your Application
• Invoking the Debug Painter
• Views in the Debug Painter
• Call Stack View
• Breakpoints View
• Objects In Memory View
• Source View
• Source Browser View
• Source History View
• Variables View
• Watch View
• Breakpoints
• Conditional Breakpoints
• Breakpoint On a Counter Value
• Both Condition & Occurrence Breakpoints
• Breakpoint On a Variable Change
• Breakpoints in Embedded SQL
• Editing Breakpoints
• Enabling and Disabling Breakpoints
• Flow In the Debug Window
• Step-in
• Step-over
• Step-out
• Running to the Cursor
• Changing Variable Values
• Just-in-time Debugging
• Debugging Inherited Objects
• Solutions To Common Debugging Problems
• MessageBox()
• KeyDown(), GetObjectAtPointer()
• Messages
• Closing the Debug Window
• Remote Debugging
• Tracing PowerBuilder's Internal Execution
• Logging SQL Statement Execution
• Tracing ODBC Driver Manager Calls
• Tracing and Performance Analysis
• Collecting Trace Data - An Easy Way
• Performance Analysis - An Easy Way
• Class View
• Routine View
• Trace View
• Collecting Trace Data using Tracing API
• Performance Modelling Objects
• Trace Modelling Objects
• Summary
• Dynamic Data Exchange
• Introduction
• DDE Concepts
• The Registration Database
• Application
• Topic
• Item
• Links
• Hot Link
• Cold Link
• DDE Events In PowerBuilder
• Using DDE With PowerBuilder
• Importing Excel Spreadsheet Using DDE
• Importing a Spreadsheet Using Clipboard
• Using Excel Names
• Hot Link With Excel
• Mail Merge
• Mail Merge Setup In MS-Word
• Running the Example
• PowerBuilder As a DDE Server
• The RemoteExec Event
• The RemoteSend Event
• The RemoteRequest Event
• Summary
• OLE — Part I
• Introduction
• What Is Linking And Embedding?
• Linking
• One-Way Links
• Two-Way Links
• Adaptable Links
• Embedding
• Linking Or Embedding
• Traditional Model, Component Object Model
• Traditional Model
• Component Object Model (COM)
• OLE Features
• Visual Editing
• Drag And Drop
• Optimized Object Storage
• Nested Object Support
• Automation
• Version Management
• Objects Defined
• Why Implement OLE?
• DDE Versus OLE
• Which One To Choose, DDE Or OLE ?
• Deciding Where To Use DDE Or OLE
• Registration Database
• The Advanced Interface Of REGEDIT
• What Can We Do With RegEdit?
• OLE - PowerBuilder Implementation
• OLE Control
• OLE Control Attributes
• Contents
• Display Type
• Activation
• Link Update
• OLE Control Attributes
• Opening a File In a OLE Control
• Opening a Sub-Storage
• Insert Class In the OLE Control
• Inserting an Existing File In the OLE Control
• Inserting an Object In the OLE Control
• Saving the Object From the OLE Control
• Saving the OLE Control as Another File
• Linking the OLE Control's Object To a File
• Getting Image From the Database To OLE Control
• Updating the Database BLOB Column From OLE Control
• Copying the OLE Control
• Cutting the OLE Control Object
• Pasting an Object In the OLE Control
• PasteSpecial()
• PasteLink()
• Editing/Printing the Object In the OLE Control
• In-Place Editing & OLE Server Menus
• OLE Columns In the DataWindow
• OLE Presentation Style DataWindow
• OLE Control In the DataWindow
• Summary