IsTemporary (MDStore Interface)

ms132817.note(zh-cn,SQL.90).gif注意:
  下一版本的 Microsoft SQL Server 将删除该功能。请不要在新的开发工作中使用该功能,并尽快修改当前还在使用该功能的应用程序。

The IsTemporary property of the MDStore interface indicates whether an object is temporary. Temporary objects are local to the session in which they are created, cannot be saved, and are not available to other users. To create a temporary object, preface the name with the tilde (~) character.

Applies To:clsAggregation, clsCube, clsPartition

Data Type

Boolean

Access

Read-only

备注

A temporary object is not stored in the repository and is not available to other users. Temporary objects persist only during the session in which they are created unless renamed or cloned to another existing object having the same class type. Objects subordinate to a temporary object, such as levels for a dimension, internally inherit the parent object's IsTemporary setting.

ms132817.note(zh-cn,SQL.90).gif注意:
  Only temporary objects can be renamed by changing the Name property. Removing the tilde (~) character from the name of a temporary object means that it is no longer temporary and prevents subsequent renaming of the object. Also, executing the Update method of a temporary object has no effect; the object is not saved to the repository unless the tilde prefix is removed by changing the Name property.

Examples

Creating a Temporary Object

Use the following code to create a temporary dimension object that is renamed and saved to the repository:

'Assume an object (dsoCube) of ClassType clsCube exists.
Dim tmpDim As DSO.Dimension
Set tmpDim = dsoCube.Dimensions.AddNew("~MyDim") 'Temporary
'Add levels, member properties, process, etc.
...
'This is something we want to keep - so drop "~".
tmpDim.Name = "MyDim" 'No longer temporary
tmpCube.Update

请参阅

参考

Dimension Interface
MDStore Interface

帮助和信息

获取 SQL Server 2005 帮助