Difference between revisions of "EMPTY()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
Expressions and Type Conversion
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to check for empty value
 
Function to check for empty value
Line 22: Line 18:
 
!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
Line 47: Line 43:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
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