IdentifierQuoteChar

Description

Specifies the single quote character you want PocketBuilder to use to delimit the names of identifiers (tables, columns, indexes, and constraints) when it generates SQL statements. PocketBuilder 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 For IdentifierQuoteChar to take effect, the DelimitIdentifier parameter must be set to Yes. Otherwise, PocketBuilder's default behavior is not to delimit identifiers in SQL statements and to ignore any value specified for IdentifierQuoteChar.

Applies to

ODBC

Syntax

IdentifierQuoteChar = ‘quote_character’

Parameter	Description
quote_character	The single character you want PocketBuilder to use instead of your driver's or data provider’s default quote character to delimit the names of identifiers in SQL statements

Default

None

PocketBuilder searches the following in this order to determine the IdentifierQuoteChar value:

The section for your database profile in the PocketBuilder initialization file (in the development environment) or the value of the Transaction object DBParm property (in a PocketBuilder application).
The section for your ODBC driver in the pkodb25 initialization file.

If PocketBuilder 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.

Usage

By default, some drivers return quote characters that do not work with PocketBuilder’s parsing routines, such as the backquote character (`). As a result, delimiting is turned off for these drivers in PocketBuilder.

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.

Examples

Example 1

To specify c as the quote character you want PocketBuilder to use to delimit identifiers in SQL statements:

Database profile Type c in the Identifier Quote Character box on the Syntax tab in the Database Profile Setup dialog box.
PocketBuilder application script Type the following in a PocketBuilder application script:
```
SQLCA.dbParm = "IdentifierQuoteChar = 'c'"
```