Le 23/01/2012 19:07, M. Cs. a écrit : > I found a way to do, but I didn't understand what Benoit wanted: > If I have a query, I can always do the following: > Replace > "SELECT * FROM CATALOGS WHERE VName=....." > with > "SELECT * FROM CATALOGS WHERE "& DB.Subst("VName=&1",...)& "..." > > That can solve the problem. > I'm sorry but something can be very obvious for you, and not so clear > to somebody not involved into Gambas! From the documentation I > couldn't tell what is the difference between the quotation used by > DB.Exec() and what's the gain from a function like DB.Subst(). > This is really a painfull point in the documentations. > > Thanks anyway! > Csaba > >>
DB.Exec() & its friends internally use DB.Subst(), which does the quoting and nothing more. -- 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