Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

IdentifierQuoteChar – PB Docs 126 – PowerBuilder Library

IdentifierQuoteChar – PB Docs 126

  2. Powerbuilder Documentation
  3. Powerbuilder Documentation Older
  4. Powerbuilder Documentation 12.6
  5. IdentifierQuoteChar – PB Docs 126

IdentifierQuoteChar database parameter

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.

note.png DelimitIdentifier must be set to Yes

In order for IdentifierQuoteChar to take effect, the DelimitIdentifier
parameter must be set to Yes. Otherwise, PowerBuilder’s default
behavior is not to delimit identifiers in SQL statements and to ignore any
value specified for IdentifierQuoteChar.

Controls

  • ADO.NET

  • JDB JDBC

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

  • OLE DB

Syntax

Parameter

Description

quote_character

The single character you want PowerBuilder 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

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 PBODB126
    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.

note.png When using the OLE DB interface

If no value is specified for the IdentifierQuoteChar parameter, PowerBuilder does
not use a quote character.

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

To specify c as the quote character
you want PowerBuilder 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:

See Also

Document get from Powerbuilder help
Thank you for watching.
Powerbuilder Documentation 12.6
and Functions Events Objects and Controls PB Docs 126 PowerBuilder .NET Powerbuilder Documentation Powerbuilder Documentation 12.6 Powerbuilder Documentation Older PowerBuilder Extension Reference PowerBuilder New Features 12.6 PowerDesigner Integration System Object Properties Using the ADO.NET Interface
August 14, 2023
Was this article helpful?
2
1
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x