다음을 통해 공유


OpenQuoteChar (clsDataSource)

[!참고]

  이 기능은 다음 버전의 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