LogiView

Free Definition Join Conditions

  These WHERE clauses enable you to define links between any two tables using free definition table fields. Compared table fields can either be part of the same or of different tables.

However, table types must be identical.

 

Syntax:

  {STR_EXPR}{WHR_CMP}:{STR_EXPR}
 

{STR_EXPR}

String expression with the name of a table field in the form 'table name.column name'.

{WHR_CMP}

         

Comparison operator:

> greater
< smaller than
= equal to
<> not equal to
>= greater or equal to
<= smaller or equal to

{STR_EXPR}

String expression with the name of the second table field in the form 'table name.column name'.

 

Example:

  Definition of a selection condition as argument of a 'where' command (part of the combined select instruction):
where("MAT.MAX_WIDTH" = :"MAT.ISO")
  Result:
 

Records of the "MAT" table are selected whose "MAX_WIDTH" and "ISO" fields have the same contents.

'Select' command, integer function 'exec_select', keywords: 'art_agg', 'art_ref', 'art_typ'.