EMPTY()

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