Defining check parameters

You define additional check parameters for data constraints where standard check parameters are not sufficient.

ϖTo define additional check parameters:

1Click the Additional Checks tab in the property sheet of an attribute or domain.

The Additional Checks page appears.

2Type SQL expression using the variables %MINMAX%, %LISTVAL%, and %RULES%.

3Click OK.

Using a validation rule in check parameters

A validation rule is a rule that validates data based on a corresponding business rule. A validation rule can be generated as a check parameter when the following conditions apply:

Validation rule is attached to a class, attribute, or domain

Validation rule is defined as a server expression

132

Page 142
Image 142
Sybase 7.5 manual Using a validation rule in check parameters, To define additional check parameters, 132