CloseQuoteChar (clsDataSource)
.gif "ms133456.note(de-de,SQL.90).gif") Hinweis: |
|---|
| Dieses Feature wird in der nächsten Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature nicht zum Entwickeln neuer Anwendungen, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird, zum frühstmöglichen Zeitpunkt ein. |
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
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 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
Siehe auch
Verweis
clsDataSource
FromClause (Dimension Interface)