Difference between revisions of "ISBLANK()"
From Lianjapedia
Helen.george (Talk | contribs) |
|||
(5 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to check for empty value | Function to check for empty value | ||
− | |||
==Syntax== | ==Syntax== | ||
ISBLANK(<expC> | <expD> | <expT> | <expL> | <memofield> | <expN>) | ISBLANK(<expC> | <expD> | <expT> | <expL> | <memofield> | <expN>) | ||
− | |||
==See Also== | ==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()]] | [[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== | ==Description== | ||
The ISBLANK() function returns .T. if the specified expression is 'empty'. | The ISBLANK() function returns .T. if the specified expression is 'empty'. | ||
− | + | {| class="wikitable" width="100%" | |
− | {| class="wikitable" | + | !width="30%"|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 | + | |valign="top"|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 | + | |valign="top"|Datetime||CTOT("") , { / / : : AM} and other SET CENTURY, SET MARK, SET SECONDS and SET DATE variations |
|- | |- | ||
|Logical||.F. | |Logical||.F. | ||
Line 31: | Line 27: | ||
|- | |- | ||
|} | |} | ||
− | |||
Line 40: | Line 35: | ||
endif | endif | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== | ||
− | + | Lianja, Lianja Server | |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
+ | [[Category:Lianja VFP Extensions]] | ||
+ | [[Category:VFP Function Extensions]] |
Latest revision as of 12:33, 1 February 2013
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
Lianja, Lianja Server