[Gambas-user] How To INSERT INTO in MySQL?

[Caveat]

>> conn.Exec("insert into UTI001 (CLEF, Langue, Backup) VALUES (&1, &2,
>> &3)", "Caveat", "EN", "C:\\Temp")

This has to be ONE LINE!

On Mon, 2012-02-06 at 02:40 -0800, abbat wrote:
> 
> 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 at 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 at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gambas-user
> > 
> > 
> http://old.nabble.com/file/p33270528/2012-02-06-123728_1440x900_scrot.png