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

Wed Aug 8 01:25:00 CEST 2012

No, that doesn't work either:

$hConn.Exec("INSERT INTO inventory VALUES(id, name)", 1, txtName.Text)

On Wed, 2012-08-08 at 01:08 +0200, Emil Lenngren wrote:
> Then you have to specify what column you want to insert to.
> Syntax: http://www.w3schools.com/sql/sql_insert.asp
> 
> The &1, &2 ... system used by gambas is to provide correct escaping and to
> prevent sql injections.
> 
> 2012/8/8 rocko <sunblaster5 at ...626...>
> 
> > No, there are several.
> > I justed wanted to test it with the first column to see if it works,
> > which it doesn't.
> >
> > Tried your suggestion:
> > $hConn.Exec("INSERT INTO inventory VALUES($1)", txtName.Text)
> >
> > Values are still not inserting.
> >
> >
> >
> > On Wed, 2012-08-08 at 00:31 +0200, Emil Lenngren wrote:
> > > Try
> > >
> > >   $hConn.Begin
> > >   $hConn.Exec("INSERT INTO inventory VALUES(&1)", txtName.Text)
> > >   $hConn.Commit
> > >
> > > Do you only have one column in that table?
> > >
> > > 2012/8/8 rocko <sunblaster5 at ...626...>
> > >
> > > > Ok I tried this:
> > > >   $hConn.Begin
> > > >   $hConn.Exec("INSERT INTO inventory VALUES(name)", txtName.Text)
> > > >   $hConn.Commit
> > > >
> > > > Without success.
> > > >
> > > > On Tue, 2012-08-07 at 23:09 +0200, M. Cs. wrote:
> > > > > I use to add fields like this:
> > > > > $hConn.Begin
> > > > > $hConn.Exec("INSERT INTO mytable
> > VALUES(&1,&2,..&N)",var1,var2,...varN)
> > > > > $hConn.Commit
> > > > >
> > > > > And I use Begin and Commit only for the large amount of insertions.
> > > > > Csaba
> > > > >
> > > > > 2012/8/7 rocko <sunblaster5 at ...626...>
> > > > >
> > > > > > Having a bit of trouble with trying to get Ganbas to add a value
> > to a
> > > > > > field in a table.
> > > > > >
> > > > > > I have a sqlite DB with a table named 'inventory' with field names
> > > > like:
> > > > > > 'name', 'start_date', 'end_date' and so on.
> > > > > >
> > > > > > I'm trying to add values to the fields using a interface, I have a
> > text
> > > > > > box to add a name to the 'name' field in the inventory table.
> > > > > >
> > > > > > But I am not having any success.
> > > > > > I'm using Gambas version 2.21 as that is in my repo and been
> > following
> > > > > > the older book "A beginners Giude to Gambas" which i think uses
> > version
> > > > > > 1.9 as a basis.
> > > > > >
> > > > > > Here is my code for the 'connect' button:
> > > > > >
> > > > > > PUBLIC SUB btnConnect_Click()
> > > > > >
> > > > > >   DIM $hConn AS NEW Connection
> > > > > >
> > > > > >
> > > > > >   TRY $hConn.CLOSE
> > > > > >
> > > > > >   WITH $hConn
> > > > > >     .Type = "sqlite"
> > > > > >     .Host = "/home/rocko/DataBases"
> > > > > >     .Name = "plant_trax"
> > > > > >   END WITH
> > > > > >
> > > > > >   TRY $hConn.Open
> > > > > >   IF ERROR THEN PRINT "Database cannot be opened. Error = ",
> > Error.Text
> > > > > >
> > > > > >   $hConn.Close
> > > > > >  END
> > > > > >
> > > > > > This works as far as I can tell as I don't get the error.
> > > > > >
> > > > > > The offending code i believe is in the btnAdd_CLICK():
> > > > > >
> > > > > > 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"
> > > > > >   rTable!name = txtName.Text
> > > > > >   rTable.Update
> > > > > >
> > > > > >   $hConn.Commit
> > > > > >
> > > > > > FINALLY
> > > > > >   DEC Application.Busy
> > > > > >   $hConn.Close
> > > > > >
> > > > > > END
> > > > > >
> > > > > > I was getting "Database cannot be opened. Error =Driver name
> > missing"
> > > > > > So I added an "$hconn.Open".
> > > > > > But now the app just hangs when I click the add new btn
> > > > > >
> > > > > > The database doesn't get updated.
> > > > > >
> > > > > > Forgive me but I'm still learning Gambas and basic.
> > > > > >
> > > > > > I had compiled a newer version of Gambas from the SVN but that was
> > on
> > > > > > another laptop that got stolen last week and I just installed what
> > ever
> > > > > > was in my repo (Crucnhbang) on my replacement, but I don't think
> > thats
> > > > > > my problem.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > ------------------------------------------------------------------------------
> > > > > > 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
> > > >
> > >
> > ------------------------------------------------------------------------------
> > > 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