Specifies whether DataWindow Designer should send a “set quoted_identifier off” instruction to the server when the DelimitIdentifier parameter is not set.
ODBC (if driver and back-end DBMS support this feature)
OLE DB
DelimitIdentifierToDB='value'
Parameter |
Description |
|---|---|
value |
Specifies whether DataWindow Designer sends a “set quoted_identifier off” instruction to the server when the DelimitIdentifier parameter is not set. Values are:
|
‘No’
When you set DelimitIdentifier to 'Yes', the “set quoted_identifier on” command is automatically sent to the database server to adjust your database connection on the server when you use ODBC or OLE DB. Otherwise, the “set quoted_identifier off” command is sent to the server.
Sending “set quoted_identifier off” to the server can cause some SQL commands to fail if the SQL code contains quotation marks. To prevent PowerBuilder from sending this instruction to the server, set the DelimitIdentifierToDB parameter to ‘No’ in the PBODB initialization file or the connection string.
To specify that DataWindow Designer should not send a set quoted_identifier instruction to the server, add the following to the appropriate section of your PBODB initialization file or your connection string:
"DelimitIdentifierToDB='No'"
