EMPTY()

From Recital Documentation Wiki
Jump to: navigation, search

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