Filter
Top Products
CHAPTER 5 Enhancing DataWindow Objects
DataWindow Designer User’s Guide 183
You should not use an expression whose runtime value is greater than the value
returned by
RowHeight. For example, you should not set the height of a column
to
rowheight() + 30. Such an expression produces unpredictable results at
runtime.
Clipping columns
You can have Autosize Height columns without an Autosize Height detail
band. If such a column expands beyond the size of the detail band in the
Preview view, it is clipped.
Modifying the data source of a DataWindow object
When modifying a DataWindow object, you might realize that you have not
included all the columns you need, or you might need to define retrieval
arguments. You can modify the data source from the DataWindow painter.
How you do it depends on the data source.
Modifying SQL SELECT statements
If the data source is SQL (such as Quick Select, SQL Select, or Query), you can
graphically modify the SQL
SELECT statement.
❖ To modify a SQL data source:
1 Select Design>Data Source from the menu bar.
DataWindow Designer returns you to the Select painter. (If you used
Quick Select to define the data source, this might be the first time you have
seen the Select painter.)
2 Modify the
SELECT statement graphically using the same techniques as
when creating it.
For more information, see “Using SQL Select” on page 121.
Modifying the statement syntactically
Select Design>Convert to Syntax from the menu bar to modify the
SELECT statement syntactically.
3 Click the Return button to return to the painter.