2012/8/8 Adam Ant <adamn...@gmail.com>
> On Wed, Aug 8, 2012 at 2:59 PM, Fabien Bodard <gambas...@gmail.com> wrote:
> > Le 8 août 2012 04:49, "Adam Ant" <adamn...@gmail.com> a écrit :
> >> 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
> >
>
> Yes, sorry Roko (and Fabien), I forgot you were trying to ADD a new row.
>
> So it's really
> rTable=$hConn.Create("Inventory")
> IF rTable.Available then
> rTable!name=txtName.Text
> TRY rTable.Update
> IF ERROR THEN
> ' your update failed, possibly because of a duplicate key
> ENDIF
> END IF
>
>
>
THen if you want to modify a specific line :
rTable=DB.Edit("Inventory", "id=&1", varId)
rTable!name=txtName.Text
rTable.Update
db.commit
Another thing, If your app use only one db with one connection, Open it on
start
for exemple your project begin on a module Main.module
'module
Private hCon as New Connection
Public Sub Main()
hCOn.TYpe= "sqlite"
hCon.Name="Mydb"
hCon.Host=user.home
hCon.Open
FormMyMain.Show
END
In FormMyMain do
PUblic sub Form_Close()
db.close
end
Public sub Button_Click()
dim rTable as result
rTable = db.find("mytable")
for each rTable
print rTable!name
next
end
in gambas 3 you can use ide to define connections of the project...
you can then use it in the project ... so main.module become :
Public sub Main()
Connections["MyConnection"].Open
End
If you use a mysql or other table with password.
You need to add that befor :
Conections["MyConnection"].Password="yourpassword"
>
>
> ------------------------------------------------------------------------------
> 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
