Skip to main content

And

Syntax​

Select              field_name
operator            value
And
Select              field_name
operator            value

Parameters​

None.

Description​

Combines consecutive Select criteria so a record must match all connected conditions.

Remarks​

Used between Select (or Select Event) blocks. See Select and Or.

And / Or logic​

  • And connects two selection criteria where both conditions must hold.
  • Or connects two criteria where either condition can hold.
  • You can have a series of Or commands followed by a series of And commands, but not the other way around.

Examples​

Select              SEX
=                   F
And
Select              AGE
>=                  40