USoft Rule Language

Previous Next

For constraint SQL, USoft offers an alternative to regular USoft-supported SQL syntax that is easier to read.

This alternative is referred to as the USoft Rule Language. Its main purpose is to demonstrate the conceptual logic of USoft constraints and the USoft Rules Engine in contexts such as introductory events and Sales demos. You may also find the USoft Rule Language helpful in a learning context.

The USoft Rule Language is not available in other contexts than constraint SQL.

In the Constraints window, if you use the USoft Rule Language, the standard SQL equivalent is displayed on a special SQL Equivalent tab page.

USoft Rule Language keywords

The main USoft Rule Language keywords are:

FOR + Object Name Plural

DO NOT ALLOW THAT (for conditional constraints, and optionally for corrective constraints)

ADD WHERE NOT EXISTS (for corrective INSERT constraints)

MAKE SURE THAT (for corrective UPDATE constraints)

CONNECTED AS (equivalent to SQL’s “RELATE”)

WHERE (equivalent to SQL's WHERE)

REMOVE ALL

FOR WHICH

GROUPED BY

See also

USoft Rule Language and table constraints

USoft Rule Language and Object Name Plurals

USoft Rule Language and domain Constraints

USoft Rule Language examples: Simple constraints

USoft Rule Language examples: Query statements with subquery

USoft Rule Language examples: Query statements with join

USoft Rule Language examples: Update statements

USoft Rule Language examples: Delete statements

USoft Rule Language examples: GROUPED BY clause

USoft Rule Language examples: Statements without conditions

USoft Rule Language examples: Variable constraint messages