Hi Woody, tried that, didn't work ---In [email protected], <[email protected]> wrote:
I think Delphi has a quoted string function which you can use when setting the parameter. However, all of the database components I’ve ever used should automatically provide that when you set a parameter to a quoted string. Which components are you using to run the query and how are you setting the parameter? Woody (TMW) From: russell@... mailto:russell@... Sent: Tuesday, October 15, 2013 12:17 PM To: [email protected] mailto:[email protected] Subject: [firebird-support] using a parameter containing a single quote running inside Delphi if I use the query select * from person where email = :email if the email address is a@... then it is fine, but if the email contains an apostrophe a'oneill@b,com then it fails to locate the record. Even if I use a string replace rather than a parameter it fails. In FlameRobin select * from person where email = 'a''oneill@...' is fine. any ideas?
