SQL Expression Editor

The SQL expression editor provides the ability to enter any valid SQL expression accordingly to the current context.

There are several contexts when a SQL expression might be used:

- Custom term definition (See input dictionary editor.)

- Scope criterion (See scope editor.)

- Relation expression (See dynamic views.)

The SQL expression editor operates in two modes:

1. Syntax check - default. Use this mode when your SQL expression does not use a database specific SQL dialect. This mode allows validation of your SQL syntax as you are modifying it.

2. No syntax check - Turn off the syntax check option if the syntax of your SQL expression goes out of the scope of TARGET's SQL interpreter capabilities (each particular database can have its very own syntax constructs).