CloseQuoteChar (clsDataSource)
.gif "ms133456.note(zh-tw,SQL.90).gif") 附註： |
|---|
| 下一版的 Microsoft SQL Server 將不再提供此功能。請勿在新的開發工作中使用此功能，並且儘速修改使用此功能的應用程式。 |
The CloseQuoteChar property of an object of ClassType clsDataSource returns the right (closing) quote character used by the source database.
Data Type
Variant
Access
Read-only
備註
To properly qualify a table or column name that contains white space, a data source may require the name be delimited or enclosed using a quote character. The quote character is generally specific to the data source or data source driver.
範例
The following code specifies a FromClause in a dimension and uses the proper delimiter characters for the data source:
'Assume an object (dsoDimension) of
'ClassType clsDatabaseDimension exists and
'get the quoting characters from the data source
Dim sLQuote As String, sRQuote As String
sLQuote = dsoDimension.Datasource.OpenQuoteChar
sRQuote = dsoDimension.Datasource.CloseQuoteChar
'Set the comma separated list of the dimension tables
dsoDimension.FromClause = sLQuote & "store" & sRQuote
請參閱
參考
clsDataSource
FromClause (Dimension Interface)