Difference between revisions of "EMPTY()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
|||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to check for empty value | Function to check for empty value | ||
| − | |||
==Syntax== | ==Syntax== | ||
EMPTY(<expC> | <expD> | <expT> | <expL> | <memofield> | <expN>) | EMPTY(<expC> | <expD> | <expT> | <expL> | <memofield> | <expN>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[CTOD()]], [[CTOT()]], [[IIF()]], [[SET CENTURY]], [[SET DATE]], [[SET MARK]], [[SET SECONDS]], [[SPACE()]], [[TYPE()]] | + | [[CTOD()]], [[CTOT()]], [[EVL()]], [[IIF()]], [[SET CENTURY]], [[SET DATE]], [[SET MARK]], [[SET SECONDS]], [[SPACE()]], [[TYPE()]] |
| − | + | ||
==Description== | ==Description== | ||
The EMPTY() function returns .T. if the specified expression is 'empty'. | The EMPTY() function returns .T. if the specified expression is 'empty'. | ||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
| Line 31: | Line 27: | ||
|- | |- | ||
|} | |} | ||
| − | |||
| Line 41: | Line 36: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
Revision as of 06:36, 1 October 2012
Contents
Purpose
Function to check for empty value
Syntax
EMPTY(<expC> | <expD> | <expT> | <expL> | <memofield> | <expN>)
See Also
CTOD(), CTOT(), EVL(), 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
