CloseQuoteChar (clsDataSource)
.gif "ms133456.note(fr-fr,SQL.90).gif") Remarque : |
|---|
| Cette fonctionnalité sera supprimée dans la prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et modifiez dès que possible les applications qui utilisent actuellement cette fonctionnalité. |
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
Notes
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.
Exemple
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
Voir aussi
Référence
clsDataSource
FromClause (Dimension Interface)