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

[Olivier Cruilles]

Hello,

I think your problem is that you don't understand how to use sqlite database..

You don't renew a connection every time you want to use it.

- You open the database at the beginning of your program
- You work with it by updating it
- Before you close you program, you close the database

So to do that use it like that:

--------------------------------------------

PUBLIC $hConn AS Connection <=  Error corrected

btnConnect CODE:

PUBLIC SUB btnConnect_Click()

 $hConn = NEW Connection     <=  line added

 $hConn.Host = "/home/rocko/DataBases"
 $hConn.Name = "my_test.sqlite"
 $hConn.Type = "sqlite"
 $hConn.Open

btnAdd CODE:

PUBLIC SUB btnAdd_Click()

 DIM rTable AS Result

 rTable = $hConn.Create("inventory")        <=  Error corrected

 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 

 DB.Commit

btnClose CODE:
PUBLIC SUB btnClose_Click()

 $hConn.Close
 FMain.Close




Cordialement,

Olivier Cruilles
Mail: linuxos at ...1896...

Le 8 août 2012 à 20:13, rocko <sunblaster5 at ...626...> a écrit :

> Is it DB.Create/DB.Commit?? I was using $hConn.Create and so on.
> 
> I'm  getting 'Connection Not Opened" error when click the Add_new btn.
> 
> 
> btnConnect CODE:
> PRIVATE $hConn AS Connection
> PUBLIC SUB btnConnect_Click()
> 
>  DIM $hConn AS NEW Connection
> 
>  $hConn.Host = "/home/rocko/DataBases"
>  $hConn.Name = "my_test.sqlite"
>  $hConn.Type = "sqlite"
>  $hConn.Open
> 
> btnAdd CODE:
> 
> PUBLIC SUB btnAdd_Click()
> 
>  DIM $hConn AS NEW Connection 
>  DIM rTable AS Result
> 
>  rTable = DB.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 
> 
>  DB.Commit
> 
> btnClose CODE:
> PUBLIC SUB btnClose_Click()
> 
>  $hConn.Close
>  FMain.Close
> 
> On Wed, 2012-08-08 at 19:48 +0200, Fabien Bodard wrote:
>> 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 <sunblaster5 at ...626...>
>> 
>>> 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 <sunblaster5 at ...626...>
>>>> 
>>>>> 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
>>>>>> 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