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?
