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

[Caveat]

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