CloseQuoteChar

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

Value

Determined by the source database.

Remarks

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.

Example

Use the following code to specify a FromClause in a dimension.

'Assume an object (dsoDimension) of

'ClassType clsDatabaseDimension exists and

'get the quoting characters from the datasource

Dim sLQuote As String, sRQuote As String

sLQuote = dsoDimension.Datasource.OpenQuoteChar

sRQuote = dsoDimension.Datasource.CloseQuoteChar

'Set the dimension type

dsoDimension.DimensionType = dimRegular

'Set the comma separated list of the dimension tables

dsoDimension.FromClause = sLQuote & "store" & sRQuote