After completing PowerBuilder 6: Using DataWindows, the user should be able to:
 

	Use edit styles and define style properties
	Create EditMasks style columns and DropDownDW style columns
	Use display formats and validation rules
	Customize DataWindows
	Set display defaults
	Use conditional expressions
	Display data and data sources
	Modify data and data sources

Using Edit Styles
 

	Assigning edit styles
	The Edit edit style
	The DropDownListBox edit style
	The RadioButton edit style
	The CheckBox edit style

EditMasks and Drop-Down DataWindows
 

	The EditMask style
	Using drop-down DataWindows

Display Formats and Validation
 

	Using display formats
	Using validation rules

Customizing DataWindows
 

	Using the Database Painter
	Defining your own edit styles
	Defining your own display formats
	Defining your own validation rules

Column Defaults and Conditionals
 

	Setting different column defaults
	Using the rows column specifications
	Using conditional expressions

Displaying Data and Data Sources
 

	Filtering
	Sorting
	Modifying your data source
	Customizing your data source viewing area

Modifying the Data Source
 

	Changing your data source
	Modifying joins
	Changing a DataWindow's columns
	Changing a DataWindow's tables
	Using the DISTINCT statement
	Using the SQL Select painter
	Using the WHERE Clause in the SQL Toolbox
	SQL statements versus DataWindow functions

Manipulating Data
 

	Retrieving data into a DataWindow
	Inserting rows into a DataWindow
	Deleting rows from your DataWindow
	Updating your database with your DataWindow
	Confirming actions before losing data
	Data retrieval
	The ItemChanged event
	Adding test data

This course is distributed with:
 

	Exercises that allow users to practice in PowerBuilder 6
	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