[Gambas-user] DB.Quote() doesn't quotes apostrophes

[Benoît Minisini]

Le 23/01/2012 14:03, M. Cs. a écrit :
> Well, that was the thing I was fearing: I must handle the characters
> by my own. The strange thing is , that if I have something like
> DB.Exec("SELECT * FROM CATALOGS WHERE VName=&1","Blackmore's Night'")
> the query won't fail.
> I can even have query
> DB.Exec("SELECT * FROM CATALOGS WHERE VName LiKE&1","%'%")
> and the result won't fail. I wonder why? What's the advance in .Exec
> over .Quote?
>
> I will try Johnny's trick.
> Thanks!
>
> Csaba
>

Did you read my mail?

-- 
Benoît Minisini