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

[Fabien Bodard]

Le 8 août 2012 04:49, "Adam Ant" <adamnt42 at ...626...> a écrit :
>
> On Wed, Aug 8, 2012 at 4:48 AM, rocko <sunblaster5 at ...626...> wrote:
> 8<
>
> > PUBLIC SUB btnAdd_Click()
> >
> >   DIM $hConn AS NEW Connection
> >   DIM rTable AS Result
> >
> >   $hConn.Open
> >
> >   TRY $hConn.Open
> >   IF ERROR THEN PRINT "Database cannot be opened. Error = ", Error.Text
> >
> >   INC Application.Busy
> >
> >
> >   $hConn.Begin
> >   rTable = "Inventory"
      <---- 1
> >   rTable!name = txtName.Text
> >   rTable.Update
      <---- 2
> >
> >   $hConn.Commit
> >
> > FINALLY
> >   DEC Application.Busy
> >   $hConn.Close
> >
> > END
>
> 1. You are trying to set a Result to a string value.  This wont work.
> 2. In order for gb.db to execute a database update it must have a
> writeable result.
>
> The answer is:
>
It's create
> rTable=$hConn.create("Inventory",<some request to get the record you
> want to update>)
> IF rTable.Available then
>   rTable!name=txtName.Text
>   rTable.Update
> END IF
>

Don't open/ close the db each time

You can use db.create too
> The help on gb.db has plenty of examples for Result and Connection
> explaining these concepts.
>
> hth
> Bruce
>
>
------------------------------------------------------------------------------
> 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