[Gambas-user] Adding values to fields in SQLite table??
rocko
sunblaster5 at ...626...
Wed Aug 8 01:02:09 CEST 2012
Oh yes '&' not '$', that was a typo.
In my code it's '&'.
Still can't get this to work.
Here is my full code:
PUBLIC SUB btnConnect_Click()
'DIM sName AS String
DIM $hConn AS NEW Connection
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
END
PUBLIC SUB btnAdd_Click()
DIM $hConn AS NEW Connection
'DIM $Value AS String
$hConn.Open
'TRY $hConn.Open
'IF ERROR THEN PRINT "Database cannot be opened. Error = ", Error.Text
$hConn.Begin
$hConn.Exec("INSERT INTO inventory VALUES(&1)", txtName.Text)
$hConn.Commit
FINALLY
$hConn.Close
END
On Wed, 2012-08-08 at 00:53 +0200, Olivier Cruilles wrote:
> Hello,
>
> > Tried your suggestion:
> > $hConn.Exec("INSERT INTO inventory VALUES($1)", txtName.Text)
>
> I think it's wrong because you write this one: VALUES($1) and it's VALUES(&1)
>
> Cordialement,
>
> Olivier Cruilles
> Mail: linuxos at ...1896...
>
> Le 8 août 2012 à 00:46, rocko <sunblaster5 at ...626...> a écrit :
>
> > 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
More information about the User
mailing list