Is functions

Uses your system voice; voice and rate in settings.

Snapshot

≈ 5 min read

Names in other languages

No names in other languages are held for this entry yet.

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

The Is functions (also known as data information functions, data inspection functions, or data-testing functions ) are a set of functions in Microsoft's Visual Basic 6, Visual Basic for Applications, VBScript, and Visual Basic .NET. Several of them are also provided in Transact-SQL by the .NET Framework Data Provider for Microsoft SQL Server.

The Is functions (also known as data information functions, data inspection functions, or data-testing functions ) are a set of functions in Microsoft's Visual Basic 6, Visual Basic for Applications, VBScript, and Visual Basic .NET. Several of them are also provided in Transact-SQL by the .NET Framework Data Provider for Microsoft SQL Server. This function determines whether the expression passed as its argument evaluates to System.DBNull.Value . This is equivalent to Visual Basic 6's IsNull() function. Note that it is not possible to directly compare an expression for equality to System.DBNull , because any expression of the form x = DbNull will evaluate to DbNull simply because it contains a null. IsDBNull() is the only way to test for equality to System.DBNull . IsEmpty(expression) This function determines whether the expression passed as its argument is an uninitialized variant. Note that an uninitialized variant is distinct from a variant that has been initialized to hold Null . Although the function takes an expression, rather than simply a variable name, any expression that isn't simply a variable name is considered not to be an uninitialized variant. This function was available in Visual Basic 6, but has been superseded in Visual Basic .NET by the IsNothing() function. In VBScript, if a variant is assigned Nothing , this function still returns False . IsError(expression) This function, in Visual Basic .NET, determines whether the expression passed as its argument is an exception object, i.e. an object of the System.Exception class or one of its subclasses. In Visual Basic 6, the function tests whether the expression is a variant with the special vbError subtype. IsMissing(name) This function determines whether the variable name passed as its argument is an optional argument that was not passed to a function by its caller. It returns True only of the variable is a variant that has not been initialized. This function only exists in Visual Basic 6. In Visual Basic .NET, optional parameters are required to have default initializers, and the function no longer exists. IsNothing(expression) This function determines whether the expression passed as its argument evaluates to Nothing . It is a simple library function (comprising just 4 CIL instructions) which can itself be written in Visual Basic as: Public Shared Function IsNothing(ByVal Expression As Object) As Boolean Return (Expression Is Nothing) End Function The effect of this is to return False for all value (non-reference) expressions, because they will be wrapped up, as part of the function call, into objects, which will by their very natures, not be null objects. To avoid this behaviour, one can use the IS operator to compare an object directly to Nothing , writing expression  IS Nothing rather than IsNothing(expression) . The compiler will raise a compile-time error if the compared expression is a value rather than a reference type, catching the type mismatch at compile time rather than simply returning False at run-time. Strings are reference types in Visual Basic .NET, and so capable of being null (as opposed to simply zero-length, empty, strings). For such strings, this function returns True . (For empty strings it returns False .) IsNull(expression) This function determines whether the expression passed as its argument evaluates to Null . A null value in any sub-expression of the expression causes the entire expression to be considered null. IsNull(expression1,expression2) This function, taking two arguments, is specific to Transact-SQL. In contrast to the Visual Basic function by this name, it does not return a Boolean , but instead returns the first expression if that is not NULL , otherwise the second expression. The purpose of the function is to replace any NULL values with another, presumably (but not required to be) non- NULL , value. It is a two-argument version of COALESCE() . IsNumeric(expression) This function determines whether the expression passed as its argument can be converted to a number (be that a Short , Integer , Long , Single , Double , or Decimal ) from a character or string, or is already a number. In Transact-SQL, strings can be converted to numbers even if they contain characters that one might not expect in numbers. This is because Transact-SQL allows conversion from money and smallmoney types to numbers, and monetary data in string form may contain currency indicator characters such as the ' £ ' or ' $ ' symbols. The same is true of VBScript, where any string that can be converted to a currency value in the current locale is considered to be numeric. VBScript does not, however, consider dates and times to be numeric. IsObject(expression) This function determines whether the expression passed as its argument is an object rather than a value. This is equivalent to Visual Basic .NET's IsReference() function. IsReference(expression) This function determines whether the expression passed as its argument is a reference rather than a value. This is equivalent to Visual Basic 6's IsObject() function.

Text derived from https://en.wikipedia.org/w/index.php?oldid=1376282269 under CC BY-SA 4.0; modifications have been made.

Provenance

snapshot enwiki-001376282269 · captured 1790133600.0 · version history

Cite this page as: encyclopegia.org, “Is functions”, snapshot enwiki-001376282269. https://encyclopegia.org/a/is-functions

Sources cited in this revision

No external citation was extracted for this revision. That is a statement about the source, not a claim that none exists.