DataWindow and DataStore basics

This part describes how to create and use DataWindow and DataStore objects.

Additional information about these objects and about the DataWindow control is available in the Working with DataWindows in Users Guide and in Data Access Techniques in Application Techniques. Reference information is available in the DataWindow Reference.

Table of Contents

About DataWindow Technology
About DataWindow objects, controls, and components
Presentation styles and data sources
Basic process
Choosing a DataWindow technology
Solutions for client/server and distributed applications
PowerBuilder DataWindow control
Using DataWindow Objects
About using DataWindow objects
Putting a DataWindow object into a control
Names for DataWindow controls and DataWindow objects
Working with the DataWindow control in PowerBuilder
Specifying the DataWindow object during execution
Accessing the database
Setting the transaction object for the DataWindow control
Retrieving and updating data
Accessing a Web service data source (Obsolete)
Importing data from an external source
Manipulating data in a DataWindow control
How a DataWindow control manages data
Accessing the text in the edit control
Manipulating the text in the edit control
Coding the ItemChanged event
Coding the ItemError event
Accessing the items in a DataWindow
Using other DataWindow methods
Accessing the properties of a DataWindow object
Handling DataWindow errors
Retrieve and Update errors and the DBError event
Errors in property and data expressions and the Error event
Updating the database
How the DataWindow control updates the database
Changing row or column status programmatically
Creating reports
Planning and building the DataWindow object
Printing the report
Using nested reports
Using crosstabs
Viewing the underlying data
Letting users redefine the crosstab
Modifying the crosstab's properties during execution
Generating HTML
Controlling display
Calling the SaveAs method
Displaying DataWindow objects as HTML forms
Dynamically Changing DataWindow Objects
About dynamic DataWindow processing
Modifying a DataWindow object
Creating a DataWindow object
Providing query ability to users
How query mode works
Using query mode
Providing Help buttons
Reusing a DataWindow object
Using DWSyntax
Describe
Modify
Create
Destroy
SyntaxFromSQL
Tips on the syntax generated by DWSyntax
Using DataStore Objects
About DataStores
Working with a DataStore
Using a custom DataStore object
Accessing and manipulating data in a DataStore
Sharing information
Example: printing data from a DataStore
Example: using two DataStores to process data
Manipulating Graphs
Using graphs
Modifying graph properties
How parts of a graph are represented
Referencing parts of a graph
Accessing data properties
Getting information about the data
Saving graph data
Modifying colors, fill patterns, and other data
Using graph methods
Using point and click
DataWindow Export/Import Template
The Export Template view for XHTML
The default XHTML export template
How tree view items are represented
Managing templates
Creating and saving templates
Selecting the template to use
Template structure
Header section
Detail section
Editing XHTML export templates
Root element
DataWindow controls
DataWindow expressions
Element attributes
Style declarations
JavaScript event handlers
CDATA sections
Element Context Menus
Selecting XHTML export templates at runtime
Exporting the DataWindow in XML or XHTML
Exporting in XML
Exporting in XHTML