.gif "ms135629.note(zh-tw,SQL.90).gif") 附註： |
|---|
| 下一版的 Microsoft SQL Server 將不再提供此功能。請勿在新的開發工作中使用此功能，並且儘速修改使用此功能的應用程式。 |
The SourceColumn property of an object of ClassType clsMemberPropertycontains a reference to the column in the dimension table that contains values for the member property.
Data Type
String
Access
Read/write
Examples
Use the following code to specify the SourceColumn for a new object of ClassType clsMemberProperty:
'Assume an object (dsoLevel) of ClassType clsDimensionLevel exists.
' Create a member property containing the name of the store manager.
Dim dsoMemProp As DSO.MemberProperty
Set dsoMemProp = dsoLevel.MemberProperties.AddNew("Store Manager")
'Set the column which contains the names of the managers.
dsoMemProp.SourceColumn = """store"".""store_manager"""