6.1. Constants, Functions, Operators, mathematical expressions
6.1.2. SQL Syntax
Prev  Next

6.1.2. SQL Syntax

[Note]Note

In the context of PARTdesigner/PARTproject, no SQL-Syntax may be used. This is especially used in the context of Strategic Parts Management.

Example: Roles -> Filter condition for datasets

Example: Roles -> Filter condition for datasets

=     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.

Prev Up Next
6.1.1. Fortran Syntax  Home 6.1.3. Constants