Home Cart [Log In] About Us Contact Us

Object Reference

Classes
Command Interface
- xf_Command
External
- xf_External_VB6_32bit
- xf_External_VB7_32_64bit
General
System Core
System Library

xf_GeneralGeneral Functions

Public Function nze0 (
varToTest As Variant,
Optional varIfMt As Variant = Null
) As Variant

Like the built in nz() function, but substitutes second value if mt_or_0() is true.

varToTest as Variant

A variant value

Optional varIfMt as Variant = Null

The empty comparison value

Call Template:

Dim v As Variant

v = xf.Gen.nze0(varToTest)

v = xf.Gen.nze0(varToTest, varIfMt)

Example 1:

nze(Null, "suprise!")   => suprise!
nze("", "suprise!")     => suprise!
nze("0", "suprise!")    => suprise!
nze(0, -1)              => -1
nze(23, -1)             => 23
nze(False, "suprise!")  => False