Grooper 21.00.0082 is available as of 12-12-2023! Check the Downloads Discussion for the release notes and to get the latest version.
Grooper 23.1.0016 is available as of 03-15-2024! Check the Downloads Discussion for the release notes and to get the latest version.
Grooper 23.00.0042 is available as of 03-22-2024! Check the Downloads Discussion for the release notes and to get the latest version.
Database Lookup SQL Issue
henryma
Posts: 63 ✭
I am trying to preform a database lookup on a value that has an ' in it. So the value is Lloyd's because of the ' , the lookup is throwing me an error. I assume this is because the SQL statement is not parsing the ' correctly? I am using Grooper version 2.8; is there a way to fix this parsing with the apostrophe with custom SQL for database lookup using the field as a variable?
0
Best Answer
-
jclark Posts: 60 ✭✭✭This issue has been reported as a bug to our development department.
As a possible work around, for the moment, if you can try adding double apostrophes such as Lloyd''s . The double apostrophes should allow the first to act as an escape character for the second.5