Manual

Our 3D CAD supplier models have been moved to 3Dfindit.com, the new visual search engine for 3D CAD, CAE & BIM models.

You can log in there with your existing account of this site.

The content remains free of charge.

15.2. Constants, Functions, Operators, mathematical expressions 15.2.2. SQL Syntax
Prev	Next

	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

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

=     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
15.2.1. Fortran Syntax	Home	15.2.3. Constants