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