# LogiView

## WHERE Clauses

| Where clauses are used for database access, to define the records of a database table, that can be selected (select), updated (update), or deleted (delete) The boolean operators 'AND' (&), 'OR' (|) and negations (!) can be used. LogiView provides the keyword 'actual' for an easy definition of WHERE clauses. You may, for example, access attributes of a selected record directly. Additionally, the 'act_fld' keyword has been provided and both describes a WHERE clause and defines a field for access. This keyword can only be used if LogiView is called as a "pre-field" or "post-field" userexit. Furthermore, you may define general WHERE clauses comprising three parts:
Name of table field (string expression) | comparison operator =, =:, <>, <, <=, >, >= | compared value (type of expression must be identical to table field type) or comparison field
| =: The value of the field is taken as compared value ( e..g. 12343) = The field name is taken as compared value ( T_GROUP_DAT.C_ID)
| ### Example:
| "T_PRO_DAT.PROJ_ID" = "235%" "SML15.C_5" >= 5*CON "T_DOC_DAT.C_ID" = "SML3.C_ID_2"
| Comparison