Specifies the single quote character you want DataWindow Designer to use to delimit the names of identifiers (tables, columns, indexes, and constraints) when it generates SQL statements. DataWindow Designer uses the quote character you specify instead of the default quote character returned by your driver or data provider.
DelimitIdentifier must be set to Yes
In order for IdentifierQuoteChar to take effect, the DelimitIdentifier
parameter must be set to Yes. Otherwise, DataWindow Designer's default behavior
is not to delimit identifiers in SQL statements and to ignore any
value specified for IdentifierQuoteChar.
ADO.NET
ODBC (if driver and back-end DBMS support this feature)
OLE DB
IdentifierQuoteChar = 'quote_character'
Parameter |
Description |
|---|---|
quote_character |
The single character you want DataWindow Designer to use instead of your driver's or data provider's default quote character to delimit the names of identifiers in SQL statements. |
None
DataWindow Designer searches the following in this order to determine the IdentifierQuoteChar value:
The section for your database profile in the DataWindow Designer initialization file
The section for your ODBC driver in the PBODB110 initialization file
If DataWindow Designer does not find an IdentifierQuoteChar value in these locations, it makes a SQLGetInfo call to your driver to return the default SQL_IDENTIFIER_QUOTE_CHAR value.
When using the OLE DB interface
If no value is specified for the IdentifierQuoteChar parameter, DataWindow Designer does
not use a quote character.
By default, some drivers return quote characters that do not work with DataWindow Designer’s parsing routines, such as the backquote character (`). As a result, delimiting is turned off for these drivers in DataWindow Designer.
However, if you paint SQL statements containing identifiers that require delimiters, syntax errors can occur if you are using a driver for which delimiting is turned off. To avoid such errors, set IdentifierQuoteChar to override the driver's default quote character.
To specify c as the quote character you want DataWindow Designer to use to delimit identifiers in SQL statements:
Database profile Type c in the Identifier
Quote Character box on the Syntax page in the Database Profile Setup
dialog box.
Application Type the following in code:
SQLCA.DbParameter="IdentifierQuoteChar='c'"
