•In regular SQL queries that you enter on “SQL Query” screen
•In WHERE Tabs on “SQL Query” screen
•In Lookup Wizard WHERE clause. It can be used in dropdowns that are dependent on any type of field, dependent on master dropdown, dependent with more complex rule than equality (i.e. age is more than selected).
•In events by using PrepareSQL function. For example, in “After Add” event you can use:
•In button’s Server code or in field events for View/Edit pages:
A full list of SQL variables:
:field - current field value on Add, Edit or Register page
:master.field - any field from master record
:session.key - any session variable
:user.field - any field from login table
:old.field - old field value (before any changes were applied)
:new.field - new field value.