SourceColumnType (Measure Interface)
[!참고]
이 기능은 다음 버전의 Microsoft SQL Server에서 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 가능한 한 빨리 수정하십시오.
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.
주의
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.
[!참고]
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