Download Designer User Manual

Designer User Manual
Figure 107: The SQL Builder
When selecting the row, you should be aware of the data types the row contains.
If you select a row
containing a memo field, you may experience errors, as Designer will interpret any line breaks (hard
returns) as new rows, and any tab characters as new columns. If these are present incomplete data will
be returned.
This dataset will appear in the Datasets drop-down list that is displayed on other data field
Properties editor tabs, and may be used to provide data required by those fields.
If a dataset is associated with a table and columns are added or removed from the table, fields that
reference the dataset may show the wrong values. This is because Designer relies on the order and
position of the database columns when associating them with form fields. If a table referenced by a
dataset does change in this way, you should select the dataset, open the Pick Tables dialog, unselect
the table and click OK, and then re-select the table.
Defining a Dataset Field’s Do This Properties
Figure 108: Dataset / Do this Tab
A dataset field’s Do this tab contains only one property: the Field is dependent on another
checkbox. Select this option if the information in this dataset may be updated based on changes
to another field.
Metastorm BPM Release 7.6
May 2008
165