[Gambas-user] Adding values to fields in SQLite table??

[rocko]

Im now getting error's.
I was getting a "connection not opened" error message, so I add
a $hConn.Open before the $hConn.Begin.
I'm now getting a "Driver name missing" error.

CODE:
PUBLIC SUB btnAdd_Click()

  DIM $hConn AS NEW Connection 
  DIM rTable AS Result
  $hConn.Open
  $hConn.Begin
  '$hConn.Exec("INSERT INTO inventory VALUES(name), txt.Name")
  '$hConn.Commit
  rTable = $hConn.Create("inventory")
  
  IF rTable.Available THEN 
    rTable!name = txtName.Text
    rTable.Update
    TRY rTable.Update
    IF ERROR THEN 
      PRINT "Update failed"
      Message.Error(ERROR.Text)
      
      ENDIF 
  ENDIF 
    
  $hConn.Commit
  $hConn.Close

On Wed, 2012-08-08 at 19:17 +0200, Fabien Bodard wrote:
> 2012/8/8 rocko <sunblaster5 at ...626...>
> 
> > Is there anyway to translate that??
> >
> google ?
> 
> 
> >
> > On Wed, 2012-08-08 at 19:01 +0200, Fabien Bodard wrote:
> > > it's in french but ...
> > >
> > > http://www.gambasforge.org/code-56-apprehender-sqlite-avec-gambas.html
> > >
> > ------------------------------------------------------------------------------
> > > Live Security Virtual Conference
> > > Exclusive live event will cover all the ways today's security and
> > > threat landscape has changed and how IT managers can respond. Discussions
> > > will include endpoint security, mobile security and the latest in malware
> > > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> > > _______________________________________________
> > > Gambas-user mailing list
> > > Gambas-user at lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/gambas-user
> >
> >
> >
> >
> > ------------------------------------------------------------------------------
> > Live Security Virtual Conference
> > Exclusive live event will cover all the ways today's security and
> > threat landscape has changed and how IT managers can respond. Discussions
> > will include endpoint security, mobile security and the latest in malware
> > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> > _______________________________________________
> > Gambas-user mailing list
> > Gambas-user at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gambas-user
> >
> 
> 
>