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

[M. Cs.]

I'm sorry Benoit, but I didn't realized that in "You must use
DB.Subst()" the You is me. I was thinking you are answering to Johnny.
I'll give a try.

Csaba

2012/1/23, Benoît Minisini <gambas at ...1...>:
> 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
>
> ------------------------------------------------------------------------------
> Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>