Difference between revisions of "EMPTY()"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 22: Line 22:
 
!Data Type||Empty
 
!Data Type||Empty
 
|-
 
|-
|Character||Space(0), "", [], '', no text entered
+
|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