Difference between revisions of "EVALUATE()"

From Lianjapedia
Jump to: navigation, search
 
 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
==Purpose==
 
==Purpose==
 
Function to evaluate a character expression and return the result
 
Function to evaluate a character expression and return the result
 
  
 
==Syntax==
 
==Syntax==
 
EVALUATE(<expC>)
 
EVALUATE(<expC>)
 
  
 
==See Also==
 
==See Also==
 
[[BETWEEN()]], [[CHROVERLAP()]], [[EMPTY()]], [[EXPRCHECK()]], [[INLIST()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[TYPE()]]
 
[[BETWEEN()]], [[CHROVERLAP()]], [[EMPTY()]], [[EXPRCHECK()]], [[INLIST()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[TYPE()]]
 
  
 
==Description==
 
==Description==
The EVALUATE() function the result of an expresion specified as a character expression <expC>. The <expC> can contain any valid expression of any data type enclosed in string delimiters.
+
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==
 
==Example==
Line 26: Line 22:
 
.T.  
 
.T.  
 
</code>
 
</code>
 
  
 
==Products==
 
==Products==
Recital Server, Recital
+
Lianja Server, Lianja
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 11:11, 21 July 2017

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