The string not finished! Gambas do not cut string. Print in one string. Gambas не дает разрывать строки как VB. Пиши все в одну строку.
2012/2/6 abbat <abbat...@mail.ru> > > > http://old.nabble.com/file/p33270528/2012-02-06-123728_1440x900_scrot.png > > > Caveat wrote: > > > > Here's some working code... > > > > conn = DataAccess.getConnection() > > conn.Exec("delete from UTI001 where CLEF = &1", "Caveat") > > conn.Exec("insert into UTI001 (CLEF, Langue, Backup) VALUES (&1, &2, > > &3)", "Caveat", "EN", "C:\\Temp") > > rSet = conn.Exec("select * from UTI001 where CLEF = &1", "Caveat") > > If rSet Not Null Then > > If rSet.Count > 0 Then > > rSet.MoveFirst > > Print rSet["CLEF"], rSet["Langue"] > > Endif > > Endif > > > > As expected, it prints: > > > > Caveat EN > > > > Regards, > > Caveat > > > > On Mon, 2012-02-06 at 09:21 +0100, Caveat wrote: > >> On Mon, 2012-02-06 at 00:14 -0800, abbat wrote: > >> > > >> > but it not work > >> > >> <sigh> > >> > >> Can you at least tell us the error message you got? Why do we have to > >> try to GUESS why it's not working? > >> > >> > >> > ------------------------------------------------------------------------------ > >> 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 > > > > > > > > > ------------------------------------------------------------------------------ > > 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 > > > > > http://old.nabble.com/file/p33270528/2012-02-06-123728_1440x900_scrot.png > -- > View this message in context: > http://old.nabble.com/How-To-INSERT-INTO-in-MySQL--tp33268576p33270528.html > Sent from the gambas-user mailing list archive at Nabble.com. > > > > ------------------------------------------------------------------------------ > 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 > -- ____ С уважением Алексей. ------------------------------------------------------------------------------ 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