ColumnSize (Level Interface)

Примечание.
В следующей версии Microsoft SQL Server эта возможность будет удалена. Не используйте ее при работе над новыми приложениями и как можно быстрее измените приложения, в которых она в настоящее время используется.

The ColumnSize property of the Level interface contains the size (in bytes) of the members in the level aggregation column in an aggregation table.

Applies To:clsAggregationLevel, clsCubeLevel, clsDatabaseLevel, clsPartitionLevel

Data Type

Integer

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 virtual cube levels and cube levels of a shared dimension (a parent Dimension object whose IsShared property is True).

Замечания

The ColumnSize property always returns 0 for (All) levels (that is, levels whose LevelType property is levAll) with a SubClassType of sbclsRegular, sbclsParentChild, sbclsLinked or sbclsMining, and for levels whose LevelType property is set to sbclsVirtual.

Set ColumnSize to be large enough to store the data type of the level. Integer values, for example, require a minimum of four bytes. If the level contains string values, find the length of the member with the longest string. Set ColumnSize greater than or equal to the length of that string multiplied by the byte size of an individual character. The ColumnSize property cannot be set to zero.

Пример

Use the following code to specify a column size of 40:

'Assume an object (dsoLev) of ClassType clsDatabaseLevel exists
dsoLev.ColumnSize = 40

См. также

Справочник

ColumnType (Level Interface)
Level Interface

Справка и поддержка

Получение помощи по SQL Server 2005