Filter
Top Products
CHAPTER 5 Enhancing DataWindow Objects
DataWindow Designer User’s Guide 185
If the data source is a
stored procedure
If you are modifying the result set for a DataWindow object whose data source
is a stored procedure, the pop-up menu for the Column Specification view
contains the menu item Stored Procedure.
Select Stored Procedure from the Column Specification view’s pop-up menu
to edit the Execute statement, select another stored procedure, or add retrieval
arguments. For more information about editing the Execute statement, see
“Using Stored Procedure” on page 137.
Storing data in a DataWindow object using the Data
view
Usually you retrieve data into a DataWindow object from the database, because
the data is changeable and you want the latest information. However,
sometimes the data you display in a DataWindow object never changes (as in
a list of states or provinces), and sometimes you need a snapshot of the data at
a certain point in time. In these situations, you can store the data in the
DataWindow object itself. You do not need to go out to the database or other
data source to display the data.
The most common reason to store data in a DataWindow object is for use as a
drop-down DataWindow where the data is not coming from a database. For
example, you might want to display a list of postal codes for entering values in
a State or Province column in a DataWindow object. You can store those codes
in a DataWindow object and use the DropDownDataWindow edit style for the
column.
For more information about using the DropDownDataWindow edit style, see
Chapter 8, “Displaying and Validating Data.”
❖ To store data in a DataWindow object:
1 If the Data view is not already displayed, select View>Data from the menu
bar.
In the default layout for the DataWindow painter, the Data view displays
in a stacked pane under the Properties view. All columns defined for the
DataWindow object are listed at the top.