• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • PowerServer problem running sql against SQL Server database

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

Resolved PowerServer problem running sql against SQL Server database

  1. Issue
0
Votes
Undo
  1. John Raghanti
    John Raghanti
  2. PowerServer
  3. Tuesday, 30 July 2024 14:10 PM UTC

Hi! I'm working on a PowerServer proof of concept, and I know that the answer to this question is probably right in front of me, but I can't see it.

Running PB 2022 R3 build 3356 and the database is Microsoft SQL Server.

I am seeing errors in the console which seem to be related to my double quotes being escaped? If I go in and manually remove all of the double quotes from the SQL, it works fine. Is there a flag or switch or something that I can do without manually editing all of the SQL in my project?

Thanks in advance!

PowerServer with Azure App Service
Monitoring PowerServer User Sessions
Accepted Answer
David Xiong @Appeon
David Xiong @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 31 July 2024 05:48 AM UTC
  2. PowerServer
  3. # Permalink

Hi John,

 

Does this issue also exist in the PB Native App? Which driver is being used in the PB Native App?

You can try setting DelimitIdentifier='Yes' in the DBParm of the Transaction to see if it resolves the issue.

 

Regards,

David

Comment
John Raghanti
  1. John Raghanti
  2. Wednesday, 31 July 2024 14:11 PM UTC
Hi David. I added that to the DBParm and it does seem to be working. Thank you. I am confused though because I did set that flag in the advanced options of the database cache. Doesn't the connection pick up those properties?
  1. Helpful
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.