Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved Double quote characters in queries

  1. How-to
0
Votes
Undo
  1. Mike Eder
    Mike Eder
  2. PowerBuilder
  3. Wednesday, 24 March 2021 18:49 PM UTC

Does anyone recall where the setting is to allow/ignore double quote characters around table and column names? I'm able to execute queries against a dw or via the DB painter, but I get an error when querying an ASA local DB when running the application via PB 2019. Thank you, ME

Deployed runtime files using PowerClient
Best method for synchronizing local to cloud datab...
Responses (4)
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 24 March 2021 19:29 PM UTC
  2. PowerBuilder
  3. # 1

Hi, Mike - 

What connection parameters are you using currently? What version of the database? What error are you receiving? Are you able to successfully establish a connection either in the app or in the IDE's Database Painter?

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 24 March 2021 19:38 PM UTC
  2. PowerBuilder
  3. # 2

Hi Mike;

  Is this what you are looking for  ...

SQLCA.DBParm = "IdentifierQuoteChar='"',DelimitIdentifier='Yes'"

Regards ... Chris

Comment
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 24 March 2021 21:29 PM UTC
  2. PowerBuilder
  3. # 3

On the PROPERTIES of a database profile, go to the SYNTAX tabpage.
The top item is what you seek.

Comment
There are no comments made yet.
Mike Eder
Mike Eder Accepted Answer Pending Moderation
  1. Thursday, 25 March 2021 00:42 AM UTC
  2. PowerBuilder
  3. # 4

Hi Chris,

I think you are close. I write that as I thought similar. However, I found that we were not doing that in the past with either of those parameters. I have PB 2017 running on a separate machine; it is working and neither of those settings exist there. It has me wondering if there's a DB ini file setting or similar somewhere else other than the initial connection to the DB parameters.

I hope I'm making some sense. The odd thing is that other team members are working fine, and they are not seeing the issue that is occurring for me.

Thank you for your reply and assistance with this,

Mike

 

Comment
Load more comments
Mike Eder
  1. Mike Eder
  2. Thursday, 25 March 2021 14:33 PM UTC
You did fine detective work. I learned that the issue was in this file. I obtained the same INI file from a team member that did not have this issue. With only replacing this one file, the issue was resolved. The odd thing... I compared all settings in the [Adaptive Server Anywhere] section (including DelimitIdentifier='YES' and IdentifierQuoteChar='"'), and all were identical. There must be another setting that ties into this issue. Thank you again for your time and assistance with this issue, Mike
  1. Helpful
John Fauss
  1. John Fauss
  2. Thursday, 25 March 2021 15:24 PM UTC
Super! I'm glad to hear you found the cause. Best wishes, John
  1. Helpful
Chris Keating
  1. Chris Keating
  2. Friday, 26 March 2021 02:08 AM UTC
What version of SQL Anywhere are you using? The [Adaptive Server Anywhere] is for older SQL Anywhere versions (v6-9 if I recall). For version 10 and later, you will be looking at the section for [SQL Anywhere].



The other option is to set the quoted_identifier option when the connection is made, i.e.;



set temporary option quoted_identifier='off'.



This can be done using EXECUTE IMMEDIATE.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.