Partager via


SourceColumnType (Measure Interface)

Notes

  Cette fonctionnalité sera supprimée dans la prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et modifiez dès que possible les applications qui utilisent actuellement cette fonctionnalité.

The SourceColumnType property of the Measure interface identifies the type of data found in the measure object's SourceColumn property.

Applies To:clsAggregationMeasure, clsCubeMeasure, clsPartitionMeasure

Data Type

ADODB.DataTypeEnum

For more information about the ADODB.DataTypeEnum enumeration, see the Microsoft® ActiveX® Data Objects (ADO) documentation.

SourceColumnType is set to one of the following values.

Column type

Value

Big Integer

adBigInt

Binary

adBinary

Boolean

adBoolean

String (Unicode)

adBSTR

Char

adChar

Currency

adCurrency

Date

adDate

Date

adDBDate

Time

adDBTime

Date & Time

adDBTimeStamp

Decimal

adDecimal

Double

adDouble

Integer

adInteger

Numeric

adNumeric

Single

adSingle

Small Integer

adSmallInt

Tiny Integer

adTinyInt

Unsigned Big Integer

adUnsignedBigInt

Unsigned Integer

adUnsignedInt

Unsigned Small Integer

adUnsignedSmallInt

Unsigned Tiny Integer

adUnsignedTinyInt

Char (Unicode)

adWChar

Text

adChar

Access

Access depends on the value of the ClassType property of the object.

Class type

Access

clsAggregationMeasure

R

clsCubeMeasure

R/W*

clsPartitionMeasure

R

* Read-only for virtual cube measures and measures in fully created linked cubes.

Notes

The SourceColumnType property works in conjunction with the SourceColumn property. Be sure to specify a SourceColumn and SourceColumnType for each measure you create for a cube.

The SourceColumnType property for a measure within a virtual cube is inherited from the measure in the underlying regular cube and cannot be changed.

Notes

  You must reference the ADO library in your project to use the ADODB.DataTypeEnum enumeration.

Examples

Use the following code to specify and read a value for the SourceColumnType property:

'Assume an object (dsoCubeMea) of ClassType clsCubeMeasure exists
dsoCubeMea.ColumnType = adCurrency
...
Dim ColType As ADODB.DataTypeEnum
ColType = dsoCubeMea.ColumnType
Select Case ColType
   Case adDouble
        ' commands for adDouble
   Case adSingle
        ' commands for adSingle
   Case Else
        ' other commands
End Select