EVALUATE()

From Lianjapedia
Revision as of 10:11, 21 July 2017 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to evaluate a character expression and return the result

Syntax

EVALUATE(<expC>)

See Also

BETWEEN(), CHROVERLAP(), EMPTY(), EXPRCHECK(), INLIST(), ISALPHA(), ISBLANK(), ISDIGIT(), TYPE()

Description

The EVALUATE() function returns the result of an expression specified as a character expression <expC>. The <expC> can contain any valid expression of any data type enclosed in string delimiters.

Example

use demo
? evaluate("customer.last_name")
Siegel
? evaluate("1+1")
2
m_var = "DATE() > {01/01/2001}"
? evaluate(m_var)
.T.

Products

Lianja Server, Lianja