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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
