Declarations Section, EmptyValue Property, NullValue Property, BlankToNull Function, BlankToValue Function, CBoolIgnErr Function, CByteIgnErr Function, CCurIgnErr Function, CDateIgnErr Function, CDblIgnErr Function, CDecIgnErr Function, CIntIgnErr Function, CLngIgnErr Function, CSngIgnErr Function, CVarIgnErr Function, CVDateIgnErr Function, EmptyToBlank Function, EmptyToNull Function, EmptyToValue Function, EqualQuotedValue Function, LengthOfType Function, MostCapableDataType Function, NonZeroToTrue Function, NullToBlank Function, NullToValue Function, PromoteToMostCapableDataType Function, ReplaceValue Function, ReplaceValueOfType Function, ReplaceVarTypeWithValue Function, SetVariants Sub, SwapNonObjects Sub, SwapVariants Sub, VariantIsBlank Function, VariantOfType Function, VariantStringToVariant Function, VariantToVariantString Function, VariantToCString Function, VariantToFixedCString Function, VariantToString Function, VariantToVBConstExpression Function, VariantToVBEvalExpression Function

Declarations Section

Empty Value Property

Return an Empty value (a Variant with a VarType of vbEmpty).

Null Value Property

Return a Variant of type Null (a Variant with a VarType of vbNull).

Blank To Null Function

Replace an empty string with a Null value. Leave all other types of values unchanged.

Blank To Value Function

Replace Empty, Null, and empty String values with some other value. Leave all other types of values unchanged.

C Bool Ign Err Function

"Convert To Boolean Ignore Errors" Attempt to convert vValue to a Boolean value. Return vValue as a Boolean value if the conversion was successful. Return False if vValue could not be converted to a Boolean.

C Byte Ign Err Function

"Convert To Byte Ignore Errors" Attempt to convert vValue to a Byte value. Return vValue as a Byte value if the conversion was successful. Return 0 (zero) if vValue could not be converted to a Byte.

C Cur Ign Err Function

"Convert To Currency Ignore Errors" Attempt to convert vValue to a Currency value. Return vValue as a Currency value if the conversion was successful. Return 0 (zero) if vValue could not be converted to a Currency.

C Date Ign Err Function

"Convert To Date Ignore Errors" Attempt to convert vValue to a Date value. Return vValue as a Date value if the conversion was successful. Return the Date represented by the number 0 (zero) if vValue could not be converted to a Date.

C Dbl Ign Err Function

"Convert To Double Ignore Errors" Attempt to convert vValue to a Double (precision floating-point) value. Return vValue as a Double value if the conversion was successful. Return 0 (zero) if vValue could not be converted to a Double.

C Dec Ign Err Function

"Convert To Decimal Ignore Errors" Attempt to convert vValue to a Decimal value. Return vValue as a Decimal value if the conversion was successful. Return Empty if vValue could not be converted to a Decimal.

C Int Ign Err Function

"Convert To Integer Ignore Errors" Attempt to convert vValue to an Integer value. Return vValue as an Integer value if the conversion was successful. Return 0 (zero) if vValue could not be converted to an Integer.

C Lng Ign Err Function

"Convert To Long Ignore Errors" Attempt to convert vValue to a Long (Integer) value. Return vValue as a Long value if the conversion was successful. Return 0 (zero) if vValue could not be converted to a Long.

C Sng Ign Err Function

"Convert To Single Ignore Errors" Attempt to convert vValue to a Single (precision floating-point) value. Return vValue as a Single value if the conversion was successful. Return 0 (zero) if vValue could not be converted to a Single.

C Var Ign Err Function

"Convert To Variant Ignore Errors" Attempt to convert vValue to a Variant (either string or numeric) value. Return vValue as a Variant value if the conversion was successful. Return Empty if vValue could not be converted to a Variant.

CV Date Ign Err Function

"Convert To Date Ignore Errors" Attempt to convert vValue to a Date value. Return vValue as a Date value if the conversion was successful. Return the Date represented by the number 0 (zero) if vValue could not be converted to a Date.

Empty To Blank Function

Replace an Empty value with a blank String. Leave all other types of values unchanged.

Empty To Null Function

Replace an Empty value with a Null value. Leave all other types of values unchanged.

Empty To Value Function

Replace Empty values with some default value. Leave all other types of values unchanged.

Equal Quoted Value Function

Returns the string expression which can be used within a Microsoft SQL WHERE clause to search for the value vValue.

Length Of Type Function

Returns the length of the internal representation of any type of value. For Empty and Null variants, returns a length of zero. For other non-strings, the length is the number of bytes occupied by the variable.

Most Capable Data Type Function

Returns the VarType of the most CAPABLE of the data types of the two arguments. The most capable data type is the one which has the widest range of values and is capable of representing vOne.

Non Zero To True Function

Return true if the argument is a non-zero numeric, date, numeric string, or date string value. Function returns False in all other cases.

Null To Blank Function

Replace a Null value with a blank String. Leave all other types of values unchanged.

Null To Value Function

Replace Null values with some default value. Leave all other types of values unchanged.

Promote To Most Capable Data Type Function

Possibly promotes one of two arguments to the more CAPABLE data type. The most capable data type is the one which has the widest range of values and is capable of representing both arguments.

Replace Value Function

"Replace One Value With Another Value" Replaces some specific value with another value. Returns all other values unchanged. Generally only supports numeric and string values.

Replace Value Of Type Function

"Replace One Value Of A Specific Type With Another Value" Replaces some specific value of a specific type with another value. Returns all other values unchanged. Generally only supports numeric and string values.

Replace Var Type With Value Function

"Replace All Values Of A Specific Type With Another Value" Replaces all values which have a specific data type with another value. Returns all other values unchanged. Generally only supports numeric and string values.

Set Variants Sub

Sets one argument to the value of another. Assumes that the arguments are of compatible types.

Swap Non Objects Sub

Swap two values that are not Objects or DataObjects. Assumes that the arguments are of compatible types.

Swap Variants Sub

Swap two values. Assumes that the arguments are of compatible types.

Variant Is Blank Function

Return True if argument is Empty, Null, or a blank String. Function returns False otherwise.

Variant Of Type Function

Return a value of the specified data type.

Variant String To Variant Function

"Variant String To Variant Value" or "Variant Value From Variant String" Converts from a "Variant String" back to the original value. For the purposes of this function, a "Variant String" is one which represents some type of value and also contains information about the type of value being represented. Inverse of the VariantToVariantString function.

Variant To Variant String Function

"Variant Value To Variant String" or "Variant String From Variant Value" Represents any type of value as a "Variant String." For the purposes of this function, a "Variant String" is one which represents some type of value and also contains information about the type of value being represented. Inverse of the VariantStringToVariant function.

Variant To C String Function

Convert a value into a C string (a string with a Nil (Chr$(0)) terminating character). This function is usually used to prepare Visual Basic strings for passing to C language DLLs such as the Windows API functions. This function should only be used to pass strings to Windows API functions which cannot possibly lengthen the string.

Variant To Fixed C String Function

Create a C string of length vCStringSize and copy vBasicString into it. Normally used to allocate a string with enough space to receive a string value back from Windows API function calls.

Variant To String Function

Converts any type of Variant into a string. Null and Empty is converted to a zero-length string.

Variant To VB Const Expression Function

"Variant To Visual Basic Constant Expression" Return the string representation of any type of value as it would appear within Visual Basic code.

Variant To VB Eval Expression Function

"Variant To Visual Basic Eval Expression" Return the string representation of any type of value as it would appear within a Visual Basic (non-Const) expression. Converts the value of a variant into a string that can be passed to the Eval function (in Access and Excel only).

This Windows-based ActiveX DLL provides many useful routines through its function-bearing and data structure classes. Consult the Help file for more information, or call us at 1-310-472-3736. For the latest news and files, visit our home page on the World Wide Web: http://www.entisoft.com