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: [email protected] Sent: Tuesday, October 15, 2013 12:17 PM To: [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 [email protected] 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''[email protected]' is fine. any ideas?
