PowerBuilder Online Courses

Introduction to PowerBuilder 7

• An Introduction to PowerBuilder
• PowerBuilder Features
• Version 7.0 Features
• PowerBuilder Editions
• Multi-tier deployment
• Wired for the Web
• Open Technology
• Developer Productivity
• Miscellaneous Features
• PowerBuilder Family of Products
• InfoMaker
• PowerDesigner
• Adaptive Server Anywhere
• PowerBuilder Library for Lotus Notes
• PowerBuilder Library for Pen Computing Interface
• Translation Assistant
• Funcky Library
• PowerBuilder Library for NetWare
• Object Cycle
• Enterprise Application Studio
• Summary
• PowerBuilder Environment
• Starting PowerBuilder
• Creating Shortcuts
• Toolbars
• Powerbar
• Painterbar
• Stylebar
• Customizing a Toolbar
• Adding an icon to the Toolbar
• Deleting a Toolbar Icon
• Custom Toolbars
• Creating New Custom Toolbar
• Deleting a Custom Toolbar
• Customizable Weblinks on PowerBuilder Menu
• To-Do-List Organizer
• PowerBuilder Development Environment
• Displaying a Pane's Titlebar
• Moving and Resizing a Pane
• Docking and Floating a Pane
• Adding and Removing a Pane
• Other Customizations
• Summary
• Questions & Answers Q. What's a PowerTip? A. PowerTip is a short description of the toolbar icon that is displayed just below the mouse pointer when the mouse is moved over it, in a  rectangle area with yellow background.
• Exercises
• Your First PB Application
• Introduction
• Introduction to 'Product Management System'
• Creating a Library
• Creating an Application Object
• Writing "Hello, World!" Application
• Summary
• Window Painter
• Introduction to Window Painter
• Creating a Window
• Window Controls
• SingleLineEdit Control
• Previewing the Window
• Naming Controls
• CommandButton
• PictureButton
• EditMask
• Code Tables
• Tab Order
• MultiLineEdit
• ListBox
• DropDownListBox
• CheckBox
• RadioButton
• GroupBox
• Picture
• OLE Control
• Graph Control
• Graph Types:
• DataWindow Control
• User Object
• Horizontal and Vertical Scrollbars
• Horizontal and Vertical Trackbars
• Horizontal and Vertical Progressbars
• PictureListBox
• DropDownPictureListBox
• ListView
• TreeView
• Tab Control
• RichTextEdit Control
• Hyperlink Controls
• Drawing Objects
• Selecting Multiple Controls
• Moving Controls
• Aligning Controls
• Spacing Controls
• Sizing Controls
• The Grid
• Duplicating Controls
• Copying and Pasting Controls
• Listing Controls
• Defining Tag Values
• Window Properties
• Window Color
• Window Size, Position and Scrollbars
• Types of Windows
• Main Window
• Popup Window
• Response Window
• Child Window
• MDI Frame Window
• MDI Frame with MicroHelp
• Testing a Window
• Summary
• Window Painter - Questions & Answers
• Window Painter - Exercises
• Login Window(w_login)
• Error Information Display Window(w_error)
• A Full-featured window(w_product_master)
• A window to display your application information(w_about)
• Menu Painter
• Types of Menus
• DropDown Menus
• Cascading Menus
• Popup Menus
• Creating a Menu
• Menu Properties
• Name Property
• Locking the Name
• MicroHelp Property
• Assigning an Accelerator Key
• Assigning a Shortcut Key
• Specifying ToolbarIcon Text & PowerTip
• Specifying Space Before Toolbar Icon
• Specifying Toolbar Icon Order & Toolbar Index
• Other Options
• Assigning an Icon to the Menu Item
• Dividing Menu Items into Logical Groups
• Previewing a Menu
• Menu Guidelines
• Summary
• Questions & Answers
• Exercises
• m_sheet_menu
• m_mdi_menu
• m_popup_menu
• Database Painter
• Introduction
• Invoking the Database Painter
• Creating a Database
• Creating units Table
• Column Attributes
• Extended Attributes
• Format Styles
• Date and Time Formats
• Edit Styles
• Validation Rules
• Defining Primary Keys
• Defining Foreign Keys
• Creating Indexes
• Data Manipulation
• Importing Data
• Exporting Data
• Sorting Data
• Filtering Data
• Displaying Rows Description
• Print Previewing, Zooming & Printing the Data
• Getting the System Tables back in Sync
• Using Logs
• PowerBuilder Attributes and System Tables
• Interactive SQL from the DB Painter
• Executing SQL Statement
• Query Plan
• Commenting Code
• Painting the SQL Statement
• Viewing Stored Procedure Syntax
• Executing a Stored Procedure
• Maintaining Database Users
• Maintaining Table Security
• Database Profiles
• Connection Options
• System Options
• Transaction Options
• Syntax Options
• Network Options
• Other Options
• ODBC
• ODBC Architecture
• The ODBCINST.INI File
• The ODBC.INI File
• The PBODB70.INI File
• Summary
• Questions & Answers
• Exercises
• DataWindow Painter
• What's a DataWindow?
• How to Use a DataWindow?
• Creating a DataWindow
• DataWindow at Design Time
• Data Source Definition View
• Design View
• Preview View
• Connecting to a Data Source
• Quick Select Data Source
• Switching Between Views
• SQL Select Data Source
• Where Clause
• Sorting the Result Set
• Group By Clause
• Having Clause
• Compute Clause
• Syntax
• The DISTINCT Clause
• Retrieval Arguments
• Joining Tables
• Saving as a Query
• Query as a Data Source
• External Data Source
• Stored Procedures as Data Source
• DataWindow Presentation Styles
• FreeForm Presentation Style
• Tabular Presentation Style
• Grid Presentation Style
• Group Presentation Style
• N-Up Presentation Style
• Label Presentation Style
• Crosstab Presentation Style
• Graph Presentation Style
• Composite Presentation Style
• Nested Reports
• RichText Presentation Style
• Sorting & Filtering Data
• Prompt for Criteria
• Data Retrieve Properties
• Suppressing Repeating Values
• Specifying Data to be Retained
• DataWindow Options
• Column Specifications
• Displaying Column's Data as Picture
• Column Edit Style & Validation Rule
• Changing the Record Height Automatically
• Sliding Objects
• Computed Fields
• Print Specifications
• Preview Options: Split Horizontal Scrolling
• Summary
• Review Questions & Answers
• Exercises
• d_units_maint
• d_units_dropdown
• d_product_custom_query
• d_display_product
• d_products_maint
• d_trans_data_entry_header
• d_trans_data_entry_detail
• d_transactions_monthly_rep
• d_error_info_display
• Design View Screen Shot
• PowerScript Basics
• Introduction to Script Painter
• Event Driven Programming
• Scripting Basics
• Identifiers
• Variable Declarations
• Standard Data Types
• Accessing Object's Attributes
• Functions
• Comments
• Line Continuation Character
• Compound Statements
• Scripting Structures
• IF
• DO WHILE...LOOP
• DO UNTIL...LOOP
• DO� LOOP WHILE
• DO �LOOP UNTIL
• FOR...NEXT
• CHOOSE CASE...END CHOOSE
• Labels, GOTO Statement
• Arrays
• Exit Statement
• Continue Statement
• Special Characters
• PowerScript Pronouns
• Errors and Warnings
• Summary
• Review Questions & Answers
• Exercises
• PowerScript - Database Operations
• The Transaction Object
• Connecting to the Database
• Allowing the User to Cancel the Login
• Linking DataWindow to the Database
• Database Independence
• Multiple Database Support
• Retrieving Data from the Database
• Adding a Row to the DataWindow
• Deleting a Row from the DataWindow
• Saving Changes to the Database
• Sorting the Data
• Filtering the Data
• Printing the Report
• Print Previewing the Report
• Setting up the Printer
• Exporting Data to Another Format
• Querying the Database Dynamically
• Sharing Data between DataWindows
• Populating User Defaults in the Login Window
• Saving User Defaults
• User Defaults � Registry Database
• CONSTANTS in PowerScript
• Displaying Help in the Login Window
• Retrieve Only as Needed
• Prompt for Criteria
• Error Handling
• The Continue CommandButton
• The Abort CommandButton
• The Print CommandButton
• The cb_Save_to_Log CommandButton
• Error Signaling
• Events and Messages
• Parameterized Events
• Events and Return Values
• Triggering an Event
• Triggering Events Dynamically
• Cascaded Events and Functions
• Does TriggerEvent Really Trigger an Event?
• Posting an Event
• Summary
• Review Questions & Answers
• Exercises