Unique Checks

The following XML model checks are made on uniques:

Check

Description and Correction

Unique name and code uniqueness

Unique constraint names and codes must be unique in the model.

Manual correction: Modify the duplicate name/code.

Automatic correction: Appends a number to the duplicate name/code.

Existence of fields

A unique constraint must contain at least one field.

Manual correction: Add at least one field to the unique constraint or delete the unique constraint. For example: @numEmployee.

Automatic correction: Deletes unassigned unique constraint.

For more information on fields, see Specifying Constraint Fields.

Undefined Selector

You must define an XPath expression for a unique constraint selector attribute.

Manual correction: In the unique constraint property sheet, define an XPath expression for the unique constraint selector attribute. For example: s:company/s:employee.

Automatic correction: None

For more information on XPath expressions, see Specifying a Constraint Selector.


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com