• Artikel

OpenQuoteChar (clsDataSource)

HinweisHinweis

  Diese Funktion wird in der nächsten Version von Microsoft SQL Server entfernt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie so bald wie möglich das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

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

Hinweise

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.

Beispiel

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