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