Difference between revisions of "ISBLANK()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to check for empty value
 
Function to check for empty value
Line 10: Line 8:
  
 
==See Also==
 
==See Also==
[[CTOD()]], [[CTOT()]], [[IIF()]], [[SET CENTURY]], [[SET DATE]], [[SET MARK]], [[SET SECONDS]], [[SPACE()]], [[TYPE()]]
+
[[CTOD()]], [[CTOT()]], [[IIF()]], [[IS_ARRAY()]], [[IS_FLOAT()]], [[IS_INT()]], [[IS_OBJECT()]], [[IS_STRING()]], [[ISALPHA()]], [[ISDIGIT()]], [[ISLOWER()]], [[ISUPPER()]], [[SET CENTURY]], [[SET DATE]], [[SET MARK]], [[SET SECONDS]], [[SPACE()]], [[TYPE()]]
  
  
Line 45: Line 43:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 11:04, 12 November 2009

Purpose

Function to check for empty value


Syntax

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


See Also

CTOD(), CTOT(), IIF(), IS_ARRAY(), IS_FLOAT(), IS_INT(), IS_OBJECT(), IS_STRING(), ISALPHA(), ISDIGIT(), ISLOWER(), ISUPPER(), SET CENTURY, SET DATE, SET MARK, SET SECONDS, SPACE(), TYPE()


Description

The ISBLANK() 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 isblank(name + address)
    dialog box "Name and address not specified."
endif


Products

Recital, Recital Server