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

[Fabien Bodard]

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 <sunblaster5 at ...626...>

> 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
> > >
> >
> >
> >
>
>
>
>
> ------------------------------------------------------------------------------
> 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
>



-- 
Fabien Bodard