powered by CADENAS

Manual

Manual

6.1.2. SQL Syntax

SQL-Syntax

=     gleich
<>    ungleich
>     größer
<     kleiner
>=    größer gleich
<=    kleiner gleich
AND
OR

The following examples show key values:

  • 1

    The expression is always true.

  • ERPTABLE.PRICE<=0.8

    The expression is true, if the respective field of the column PRICE has a value lower or equal than 0.8.

  • LINKTABLE.ERP_PDM_NUMBER<>''

    The expression is true, if the respective field of the column ERP_PDM_NUMBER is not equal empty.

  • (LINKTABLE.ERP_PDM_NUMBER<>'') AND (ERPTABLE.PRICE3>0.0)

    The expression is true, if the respective field of the column ERP_PDM_NUMBER is not equal empty AND the respective field of the column PRICE has a value greater than 0, in other words a pricing is available.

  • ((LINKTABLE.ACTIVE_STATE=1) AND (ERPTABLE.STANDORT1<>''))

    The expression is true, if the respective field of the column ACTIVE_STATE has the value 1 (= released) AND the respective field of the column STANDORT1 is not equal empty, in other words has an entry.