Private $hConn as New Connection Public sub _New() $hConn .Host = "dir of bdd" $hConn.Name = "MyBdd" $hConn.Type = "sqlite" $hConn.Open
End PUBLIC SUB btnAdd_Click() DIM rTable AS Result rTable = DB.Create("inventory") rTable!name = txtName.Text TRY rTable.Update IF ERROR THEN PRINT "Update failed" Message.Error(ERROR.Text) return ENDIF DB.Commit end Public SUb Form_Close $hConn.CLose end 2012/8/8 rocko <sunblast...@gmail.com> > 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 <sunblast...@gmail.com> > > > > > 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@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@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@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > -- Fabien Bodard ------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user