---In firebird-support@yahoogroups.com, <firebird-support@yahoogroups.com> 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@...

Sent: Tuesday, October 15, 2013 12:17 PM

To: firebird-support@yahoogroups.com

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?