Hi Marcelo!

I'm used to having to double apostrophes when using it within strings in Delphi (i.e. use "''" rather than "'") since it otherwise is considered as an end of string. Try it and see if it works.

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Marcelo
Sent: 12. juni 2009 01:52
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Octets search

Hi all!
How do I write a secure sql sentence involving a condition on a char(16) octects field(GUID)?
In a delphi dataset the sql is something like this:
"select product from table where guid=:guid"
It works with most conbinations, but when the array includes a "'"(aphostrophe) it fails...
Thanks in advance.
Marcelo.