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

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?


Best Answer

Sign In or Register to comment.