OpenQuoteChar (clsDataSource)
.gif "注意") 注意 |
|---|
下一版本的 Microsoft SQL Server 将删除该功能。 请不要在新的开发工作中使用该功能，并尽快修改当前还在使用该功能的应用程序。 |
The OpenQuoteChar property of an object of ClassType clsDataSource contains the left (opening) 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 for 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