Difference between revisions of "EMPTY()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 22: | Line 22: | ||
!Data Type||Empty | !Data Type||Empty | ||
|- | |- | ||
| − | |Character||Space(0), "", [], | + | |Character||Space(0), "", [], ‘’, no text entered |
|- | |- | ||
|Date||CTOD(""),{}, {00/00/0000}, { / / } and other SET CENTURY, SET MARK and SET DATE variations | |Date||CTOD(""),{}, {00/00/0000}, { / / } and other SET CENTURY, SET MARK and SET DATE variations | ||
Revision as of 16:06, 23 March 2009
Class
Expressions and Type Conversion
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 Database Server, Recital Mirage Server, Recital Terminal Developer
