CloseQuoteChar (clsDataSource)

メモ :
この機能は、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)

ヘルプおよび情報

SQL Server 2005 の参考資料の入手