ColumnType (Level Interface)
.gif "ms133917.note(fr-fr,SQL.90).gif") Remarque : |
|---|
| 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 ColumnType property of the Level interface contains the data type of the level member key column.
Applies To:clsAggregationLevel, clsCubeLevel, clsDatabaseLevel, clsPartitionLevel
Data Type
ADODB.DataTypeEnum
The ColumnType property is set to one of the following enumerated values.
| Column type | Value |
|---|---|
Big integer |
adBigInt |
Binary |
adBinary |
Boolean |
adBoolean |
String (Unicode) |
adBSTR |
Char |
adChar |
Currency |
adCurrency |
Date |
adDate |
Date |
adDBDate |
Time |
adDBTime |
Timestamp |
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 |
Text (Unicode) |
adWChar |
Text |
adChar |
Access
Access depends on the value of the ClassType property of the object.
| Class type | Access |
|---|---|
clsDatabaseLevel |
R/W* |
clsCubeLevel |
R/W** |
clsPartitionLevel |
R |
clsAggregationLevel |
R |
* Read-only for levels with automatic grouping (a level whose Grouping property is groupingAutomatic).
** Read-only for virtual cube levels and cube levels of a shared dimension (a parent Dimension object whose IsShared property is True).
Notes
The ColumnType property determines how the server will bind the member key column. This property must be set to a compatible type or processing the dimension or cube will result in an error.
The ColumnSize property always returns adInteger for levels with a SubClassType of sbclsRegular, sbclsParentChild, sbclsLinked, or sbclsMining that use automatic grouping (that is, the Grouping property is groupingAutomatic). Additionally, this property always returns adVarChar for levels with a SubClassType of sbclsVirtual.
Exemple
Use the following code to specify an integer ColumnType:
' Assume an object (dsoDim) of ClassType clsDimension exists
Set dsoLev = dsoDim.Levels.AddNew("Store Id")
dsoLev.MemberKeyColumn = """store"".""store_number"""
dsoLev.ColumnSize = 4
dsoLev.ColumnType = adInteger
dsoLev.EstimatedSize = 24
Voir aussi
Référence
ColumnSize (Level Interface)
Level Interface
Autres ressources
Traitement et modes de stockage des partitions