DataCard Ultragrafix 285 Dokumentacja Pobierz pdf (Strona 78)

68 Searching the Data Source

ID Works Standard and Enterprise Version 5 Operator’s Guide

You can use the Include NULL values option with the Exclude

constraint detail option.

> Constraint Rule

Use the > rule to find records with values greater than the value

entered (that is, more positive). Example: where EMPLOYEE.AGE >

Exclude Option

If you select Exclude constraint detail, the search will return all

records with values less than or equal to the value you entered.

Example: where EMPLOYEE.AGE <= 65

NULL Option

If you select Include NULL values, the search will return all records

with NULL values in addition to records that contain values greater

than the value you entered. Example: where ((EMPLOYEE.AGE >

65) OR (EMPLOYEE.AGE IS NULL))

You can use the Include NULL values option with the Exclude

constraint detail option.

< Constraint Rule

Use the < rule to find records with values less than the value entered

(less positive). Example: where EMPLOYEE.AGE < 18

Exclude Option

If you select Exclude constraint detail, the search will return all

records with values greater than or equal to the value you entered.

Example: where EMPLOYEE.AGE >= 18

NULL Option

If you select Include NULL values, the search will return all records

with NULL values in addition to records that contain values less than

the value you entered. Example: where ((EMPLOYEE.AGE < 18) OR

(EMPLOYEE.AGE IS NULL))

1 2 ... 73 74 75 76 77 78 79 80 81 82 83 ... 305 306

Brak uwag

DataCard Ultragrafix 285 Dokumentacja Strona 78