Creating Dynamic DataWindows
\The Sandbox \PB History & Future \New in PB 2 \Painter Features \DataWindow Painter \Dynamic DWs
Assigning
Accelerators
Tag Values
DW Icon
Comments
Changing
Databases
Controlling DW
Updates
OLE Columns
DataWindow
Reports
Dynamic DWs
Runtime Print
Specifications
Displaying the
DDLB Arrow
Displaying
Row Counts
Sort and Filter
Testing
Modifying Result
Sets Descriptions
Moving Object
with Keyboard
Naming Objects
Aggregate
Functions
New Color Bar
Events
DW Functions
New Menu Items
Grid Style
Shortcut Keys
Align Objects
Size Objects
Space Objects
Saving DWs
with Comments
Keyboard Object
Selection
Selecting a Font
Selecting a
Line Edit
Keyboard Sizing
Specifying
SQL Syntax
Background
Color
Timer Interval
Unit of Measure
Validation
Message
DB Table
Changes
Suppressing
Repeating Values
Testing an
OLE Column
Using Comments

Dynamic DataWindows allow you to create and modify DataWindows on the fly. 

To create a DataWindow dynamically, use the dwCreate function.

dwCreate takes two arguments:  the name of the DataWindow that will be replaced by the new DataWindow, and the syntax for creating the new DataWindow.  You can create the DataWindow syntax programmatically, but it is easier to:

Use the dwSyntaxFromSQL function to generate the syntax from a SELECT statement

Create prototype syntax and then use the prototype syntax in dwCreate

To create prototype syntax:

  1. Create a DataWindow using the DataWindow Painter.
  2. Export the source of the DataWindow using the Export feature in the Library Painter.
  3. Change the syntax of the source in a text editor.  For example, you might want to change the columns or the format, add a DataWindow object, or change the groups.
  4. Save it.
PBL Peeper PB Help PB History
& Future About Us Feedback Site Map

Google
 
Web www.techno-kitten.com
www.sybase.com