USoft Rule Language Examples: Variable constraint messages
In USoft it is possible to use values from violating records in the constraint message that is presented to the end user. To make this possible, the columns from which these values are taken must be explicitly enumerated in the select-list of the constraint statement.
Unlike SQL syntax, the standard USoft Rule Language syntax is not suitable for expressing these values.
However, if the statement is USoft Rule Language then the constraint checker will attempt to resolve variables in the constraint message even though columns are not explicitly stated
If resolution is successful, the select-list items are generated into the select-list of the SQL equivalent.
If resolution of message variables in combination with a USoft Rule Language statement is NOT successful, then the constraint checker must throw a restrictive error message.