Modifying the Result Sets Descriptions
\The Sandbox \PB History & Future \New in PB 2 \Painter Features \DataWindow Painter \Modifying Result Sets Descriptions
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

You can modify the data source that is use to build the DataWindow.  If the source is an SQL Select statement, you can modify the SELECT statement.  If the source is a script or a database stored procedure, you can modify the result set description.

To modify the data source:

  1. Select Edit Data Source from the Rows Menu.  If the data source is and SQL SELECT statement, the Modify SQL Select window displays.  If the data source is a script or a database stored procedure, the Modify Result Set Description window displays.
  2. Review the SELECT statement or result set description and make any necessary changes.
  3. Click OK to the changes to the statement or description and close the window. If the data source is an SQL SELECT statement, PowerBuilder verifies the statement before it saves the changes.
PBL Peeper PB Help PB History & Future About Us Feedback Site Map

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