LogiView

Command 'where'

     

This command specifies the Where clauses in catenated Selection or Update instructions.

One or more Where clauses, the keyword 'actual' specifiying the access to the currently selected record or one of the keywords 'art_agg', 'art_ref' or 'art_typ' can be used to indicate a Join selection.

In a cantenated instruction, the 'where' command can be called several times in order to specify further where clauses. In this case the following calls must start with a link operator ('|' or '&', see below).

This command must not be called with a conditional instruction.

LGV interpretes a string with the format "YYYY-MM-DD" or "YYYY-MM-DD HH:MM:SS" as a date!

 

Syntax:

 

where({WHERE|actual|DTV_JOIN}) or
where(& {WHERE|DTV_JOIN}) or
where(| {WHERE})

 

I/O parameters:

{WHERE} Where clause followed by the database access.
{actual} Keyword 'actual', used to access the current record.
{DTV_JOIN} One of the keywords 'art_agg', 'art_ref' or 'art_typ' for indicating a Join selection.
& Logic operators for AND relation.
| Logic operators for OR relation.
-  
 

Return value:

 
-  
 

Example:

  Declaration of Variables
 
 90 update(EP_MAS_ACC_INS)	

100 where("C_ID_1" = EP_MAS_CID)	

110 where(& "C_ID_2" = EP_FLD_CID)	

120 exec_update()	
  Result:
  The variable value "EP_MAS_ACC_INS" is written to the defined table field (defined in the variable list) if the value of the variable "C_ID_1" of the table is equal to the value of the variable "EP_MAS_CID" and "C_ID_2" is equal to "EP_FLD_CID".

Functions and commands: DB/Mask Interface