SD - The Open Source, Multivalue, String, Database

 

SD Basic Functions - ABS() and ABSS()

OpenQM 2.6.6 documentation for this command is available here.  The OpenQM documentation may provide additional context for this command.  However, some features in SD have been modified so the OpenQM information may not be 100% applicable to SD.

The ANDS() function performs a logical AND operation on successive elements of a dynamic array, returning a similarly structured dynamic array of results.

Format: ANDS(expr1, expr2)

Parameters:  expr1, expr2 are the dynamic arrays to be processed.

The ANDS() function performs the logical AND operation between corresponding elements of the two dynamic arrays and constructs a similarly structured dynamic array of results as its return value. An element of the returned dynamic array is 1 if both of the corresponding elements of expr1 and expr2 are true. Any value other than zero or a null string is treated as true.

The REUSE() function can be applied to either or both expressions. Without this function, any absent trailing values are taken as false.

Examples: (^ represents a value mark)

A contains   1VM1SM0VM0VM1FM0VM1

B contains   1VM0SM1VM0VM1FM1VM0

C = ANDS(A, B)

C now contains   1VM0SM0VM0VM1FM0VM0

See also:

EQS(), GES(), GTS(), IFS(), LES(), LTS(), NES(), NOTS(), ORS(), REUSE()