Difference between revisions of "EMPTY()"
From Recital Documentation Wiki
		
		
		
| Helengeorge  (Talk | contribs)  (→Class) | Helengeorge  (Talk | contribs)  | ||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| ==Purpose== | ==Purpose== | ||
| Function to check for empty value | Function to check for empty value | ||
| Line 45: | Line 43: | ||
| ==Products== | ==Products== | ||
| − | Recital  | + | Recital Server, Recital   | 
| [[Category:Documentation]] | [[Category:Documentation]] | ||
| [[Category:Functions]] | [[Category:Functions]] | ||
Latest revision as of 17:07, 27 November 2009
Purpose
Function to check for empty value
Syntax
EMPTY(<expC> | <expD> | <expT> | <expL> | <memofield> | <expN>)
See Also
CTOD(), CTOT(), IIF(), SET CENTURY, SET DATE, SET MARK, SET SECONDS, SPACE(), TYPE()
Description
The EMPTY() function returns .T. if the specified expression is 'empty'.
| Data Type | Empty | 
|---|---|
| Character | Space(0), "", [], , no text entered | 
| Date | CTOD(""),{}, {00/00/0000}, { / / } and other SET CENTURY, SET MARK and SET DATE variations | 
| Datetime | CTOT("") , { / / : : AM} and other SET CENTURY, SET MARK, SET SECONDS and SET DATE variations | 
| Logical | .F. | 
| Memo | No data entered | 
| Numeric | 0 | 
Example
if empty(name + address) dialog box "Name and address not specified." endif
Products
Recital Server, Recital
