Difference between revisions of "EMPTY()"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
Line 11: | Line 11: | ||
The EMPTY() function returns .T. if the specified expression is 'empty'. | The EMPTY() function returns .T. if the specified expression is 'empty'. | ||
− | {| class="wikitable" width=100% | + | {| class="wikitable" width="100%" |
− | !width=30%|Data Type||Empty | + | !width="30%"|Data Type||Empty |
|- | |- | ||
|Character||Space(0), "", [], ‘’, no text entered | |Character||Space(0), "", [], ‘’, no text entered |
Latest revision as of 12:20, 1 February 2013
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