search with apostrophe

[Roger Amar]

Thank you, Frank !

So I must check if there is an apostrophe in my SQL and escape it ?
I suppose this is available for all non-alphanumeric signs, like '?' or '!' ?

Kind regards,

Roger;


-----Message d'origine-----
De : valentina-bounces at lists.macserve.net [mailto:valentina-bounces at lists.macserve.net] De la part de Frank Schima
Envoyé : jeudi 17 mars 2005 16:08
À : Valentina Developers
Objet : Re: search with apostrophe

Hi Roger,


On Mar 17, 2005, at 6:36 AM, Roger Amar wrote:

> When I search for a phrase with an apostrophe, Valentina XCMD cannot 
> find it.
> Yet, I use "English" as language for the field.
> What is wrong ?

What is the SQL you are using? Are you escaping the apostrophe?

This works for me:
    SELECT myField FROM myTable where myField like '\''


Best regards,
Frank Schima

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina