EMPTY()

From Lianjapedia
Revision as of 08:27, 22 January 2013 by Helen.george (Talk | contribs)

Jump to: navigation, search

Purpose

Function to check for empty value

Syntax

EMPTY(<expC> | <expD> | <expT> | <expL> | <memofield> | <expN>)

See Also

CTOD(), CTOT(), EVL(), 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