devxlogo

Single Quotes in Queries

Single Quotes in Queries

Question:
When using PowerBuilder as a front end for doing SQL queries, I get the following pop-up message when I look for someone with a single quote in their name (i.e., O’Brien):

DataWindow ErrorSelect error: Unclosed quote before the character string 'o'.

The application will not allow me to find O’Briens, O’Connors, etc. How do I fix this?

Answer:
In your program you need to replace all single quotes within the query string with two single quotes (but not double quotes). So do a search and for every replace it with ‘ ‘ (but not ).

See also  Essential Measures for Safeguarding Your Digital Data
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist