Sybase InfoMaker 11.5, CD, Win, ENG Specifikace stáhnout pdf (Strana 312)

100

101

Defining validation rules

290 InfoMaker

❖ To modify a validation rule:

1 In the Database painter, open the Extended Attributes view.

2 In the Extended Attributes view, open the list of validation rules.

3 Double-click the validation rule you want to modify.

4 In the Validation Rule view, modify the validation rule as desired.

For information, see “Defining the expression” on page 290 and

“Customizing the error message” on page 291.

❖ To associate a validation rule with a column in the Database painter:

1 In the Database painter (Objects view), position the pointer on the column,

select Properties from the column’s pop-up menu, and select the

Validation tab.

2 Select a validation rule from the Validation Rule drop-down list.

The column now has the selected validation rule associated with it in the

extended attribute system tables. Whenever you use this column in a form,

it will use this validation rule unless you override it in the Form painter.

❖ To remove a validation rule from a column in the Database painter:

1 In the Database painter (Objects view), position the pointer on the column,

select Properties from its pop-up menu, and select the Validation tab in the

Properties view.

2 Select (None) from the list in the Validation Rule drop-down list.

The validation rule is no longer associated with the column.

Defining the expression

A validation rule is a boolean expression. InfoMaker applies the boolean

expression to an entered value. If the expression returns “true”, the value is

accepted. Otherwise, the value is not accepted and an error message displays.

What expressions can

contain

You can use any valid InfoMaker expression in validation rules.

Validation rules can include most InfoMaker expression functions. InfoMaker

expression functions are displayed in the Functions list and can be pasted into

the definition.

For information about these functions, see Chapter 24, “DataWindow

Expression and InfoMaker Functions.”

1 2 ... 307 308 309 310 311 312 313 314 315 316 317 ... 827 828

Komentáře k této Příručce

Žádné komentáře

Sybase InfoMaker 11.5, CD, Win, ENG Specifikace Strana 312

Komentáře k této Příručce