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 <[email protected]>
> 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 <[email protected]>
> >
> > > 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
> > > > [email protected]
> > > > 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
> > > [email protected]
> > > 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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/gambas-user
