IdentifierQuoteChar

Description

Specifies the single quote character you want PowerBuilder to use to delimit the names of identifiers (tables, columns, indexes, and constraints) when it generates SQL statements. PowerBuilder uses the quote character you specify instead of the default quote character returned by your driver or data provider.

Applies to

• ADO.NET

• JDB JDBC

• ODBC (if driver and back-end DBMS support this feature)

• OLE DB

Syntax

IdentifierQuoteChar = 'quote_character'

Default

None

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

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

2. The section for your ODBC driver in the PBODB125 initialization file or the section for your JDBC driver in the registry

If PowerBuilder 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 PowerBuilder’s parsing routines, such as the backquote character (`). As a result, delimiting is turned off for these drivers in PowerBuilder.

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 PowerBuilder to use to delimit identifiers in SQL statements:

See also