Visual Basic Scripting Edition | ÕZÑÔ…¢¿¼ |
·µ»Ø Boolean Öµ£¬Ö¸Ã÷±íß_ʽÊÇ·ñ²»°üº¬ÈκÎÓÐЧ”µ“þ (Null)¡£
IsNull(expression)
expression …¢”µ¿ÉÒÔÊÇÈÎÒâ±íß_ʽ¡£
Èç¹û expression žé Null£¬„t IsNull ·µ»Ø True£¬¼´±íß_ʽ²»°üº¬ÓÐЧ”µ“þ£¬·ñ„t IsNull ·µ»Ø False¡£Èç¹û expression ÓÉ¶à‚€×ƒÁ¿½M³É£¬„t±íß_ʽµÄÈκνM³É׃Á¿ÖÐµÄ Null ¶¼•þʹÕû‚€±íß_ʽ·µ»Ø True¡£
Null ÖµÖ¸³ö׃Á¿²»°üº¬ÓÐЧ”µ“þ¡£Null Åc Empty ²»Í¬£¬ºóÕßÖ¸³ö׃Á¿Î´½›³õʼ»¯¡£Null ÅcÁãéL¶È×Ö·û´® ("") Ò²²»Í¬£¬ÁãéL¶È×Ö·û´®ÍùÍùÖ¸µÄÊǿմ®¡£
ÖØüc ʹÓà IsNull º¯”µ¿ÉÒÔÅДà±íß_ʽÊÇ·ñ°üº¬ Null Öµ¡£ÔÚijЩÇé›rÏÂÏëʹ±íß_ʽȡֵžé True£¬ÀýÈç IfVar=Null ºÍ IfVar<>Null£¬µ«Ëü‚ƒÍ¨³£¿‚ÊÇžé False¡£ß@ÊÇÒòžéÈκΰüº¬ Null µÄ±íß_ʽ±¾Éí¾Ížé Null£¬ËùÒÔ±íß_ʽµÄ½Y¹ûžé False¡£
ÏÂÃæµÄʾÀýÀûÓà IsNull º¯”µ›Q¶¨×ƒÁ¿ÊÇ·ñ°üº¬ Null £º
Dim MyVar, MyCheck MyCheck = IsNull(MyVar) '
·µ»ØFalse
¡£MyVar = Null '
ÙxžéNull
¡£MyCheck = IsNull(MyVar) '
·µ»ØTrue
¡£MyVar = Empty '
ÙxžéEmpty
¡£MyCheck = IsNull(MyVar) '
·µ»ØFalse
¡£
IsArray º¯”µ | IsDate º¯”µ | IsEmpty º¯”µ | IsNumeric º¯”µ | IsObject º¯”µ | VarType º¯”µ