ConvertDataType Method
      
 

Description

Transforms a Data Type value between two different data type contexts.

Return Type

A Long value.   The suggested data type to use from the data types available in eTypeEnumOut for the given value lTypeValueIn in eTypeEnumIn.

Syntax

object.ConvertDataType (lTypeValueIn, eTypeEnumIn, eTypeEnumOut)

The ConvertDataType Method syntax has these parts:

PartDescription
objectAn expression evaluating to an object of type McDataManager.
lTypeValueInRequired. A Long value. The known data type. vbSingle is a data type in the mcdataLFT_Variant set.
eTypeEnumInRequired. A McDataLibFieldTypes enumeration, as described in settings. The known data type context set. vbSingle is a data type in the mcdataLFT_Variant set.
eTypeEnumOutRequired. A McDataLibFieldTypes enumeration, as described in settings. The data type context set being sought. mcdataLFT_ADODB data type set may be specified to convert the data type value for use with a McDBAttributeType.

Settings

The settings for eTypeEnumIn are:

ConstantValueDescription
 mcdataLFT_McDBLib0

McDBLib.mcDBAtbType

 mcdataLFT_ADODB1

ADODB.DataTypeEnum

 mcdataLFT_Variant2

VBA.VbVarType

The settings for eTypeEnumOut are:

ConstantValueDescription
 mcdataLFT_McDBLib0

McDBLib.mcDBAtbType

 mcdataLFT_ADODB1

ADODB.DataTypeEnum

 mcdataLFT_Variant2

VBA.VbVarType

Remarks

This function may be used to choose a McDBAttribute data type from a ADO/OLEDB or variant data item and visa-versa.