DelimitIdentifier

Description

Specifies whether you want PocketBuilder to enclose the names of tables, columns, indexes, and constraints in double quotes when it generates SQL statements. This affects the behavior of any PocketBuilder painter that generates SQL syntax.

When to specify DelimitIdentifier You must specify the DelimitIdentifier DBParm parameter before connecting to the database in PocketBuilder.

Applies to

ODBC
UL9 UltraLite 9
UL10 UltraLite 10

Syntax

DelimitIdentifier = ‘value’

Parameter	Description
value	Specifies whether you want PocketBuilder to enclose table and column names in double quotes. Values are: Yes Use double quotes. No Do not use double quotes.

Parameter

Description

value

Specifies whether you want PocketBuilder to enclose table and column names in double quotes. Values are:

Yes Use double quotes.
No Do not use double quotes.

Default

For ODBC, the default value for the DelimitIdentifier parameter depends on the DelimitIdentifer setting in the pkodb25 initialization file, which is ‘YES’ by default. For UltraLite, DelimitIdentifier=‘NO’.

Usage

For ODBC, the DelimitIdentifier DBParm setting overrides the DelimitIdentifier setting specified for your ODBC driver in the pkodb25 initialization file.

Examples

Example 1

To specify that PocketBuilder should not enclose table and column names in double quotes when it generates SQL statements:

Database profile Clear the Enclose Table And Column Names In Quotes check 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 = "Delimitidentifier='No'"
```