Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Reference Index > Referential Data Integrity in R:BASE

Constraint Messages

Scroll Prev Top Next More

When primary key, foreign key and not null constraints are defined, custom violation messages can be entered. The messages cannot be added or modified after the constraint is defined. The constraint must be deleted and re-defined to add or modify custom messages.

 

The following is an example of a constraint violation error message.

 

CEM_CannotDelete

 

 

Using two RBTI System Variables, the font size and color can be adjusted for the constraint error message. The variables are:

 

RBTI_CEM_FONTSIZE

RBTI_CEM_FONTCOLOR

 

Using the following commands, the constraint error message will display a blue font size of 14

 

SET VAR RBTI_CEM_FONTSIZE INTEGER = 14

SET VAR RBTI_CEM_FONTCOLOR TEXT = BLUE

 

CEM_CannotDelete_Large