Le 18/01/2012 14:17, M. Cs. a écrit : > Hi! > Is there any built in function in Gambas3 which can secure the > database connection from the errors caused by special characters? > > I have written functions for replacing the dangerous characters like > ', +, . and so on, but I'd like to know whether there is a way to make > queries secure from failures. > > Thanks! >
SQL quoting is automatically done by the following methods of the Connection class: Exec(), Find(), Edit(), Delete(), Subst(), provided that: - You use "&1", "&2"... inside the request string to tell where quoted arguments must be inserted. - You actually pass these arguments. Is it what you need? -- Benoît Minisini ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! 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-d2d _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
