After completing PowerBuilder 6: PowerScript and SQL the user should be able to:
 

	Explain database transactions
	Create user-defined functions
	Use arguments and DataWindow events
	Script applications to react to specified events
	Identify SQL syntax
	Create SQL commands
	Use the SQL commands and cursors

Understanding Database Transactions
 

	Exploring transaction objects
	Creating a transaction standard class

Creating Functions
 

	Implementing user-defined functions
	Creating a global function

Using DataWindow Objects
 

	Creating a DataWindow user object
	Adding your transaction user object
	Using the transaction user object

Scripting for Specific Events
 

	Triggering and posting events and functions
	Script for application events
	Script for window menu items
	Script for toolbar alignment
	Declaring user-defined events
	Script for file menu items
	Script for edit menu events
	Script for window events

Using Arguments and DataWindow Events
 

	Using function arguments
	Using event arguments
	Script for DataWindow events
	Avoiding trouble

Understanding SQL Syntax
 

	What is SQL?
	SQL syntax

SQL Commands and Cursors
 

	Using SQL transactions and testing your SQL code
	Understanding NULL
	Using cursors

This course is distributed with:
 

	Exercises that allow users to practice in PowerBuilder
	A file containing the text of the exercises
	Simulations that allow users to practice course skills even if they don't have access to the PowerBuilder product
	A PowerBuilder glossary