[sqlite] "Cannot start transaction in transaction"

[Steven Van Ingelgem]

I have a database (duh :p)... There are a few things inside... Now I add a row:

10:33:59: Transition: 'BEGIN ON CONFLICT FAIL;
INSERT INTO Address (CustomerID, Name1, Name2, Name3, Address, ZIP, City, 
CountryCode, Phone, Fax, Remark) 
VALUES            ('1',         '1',    '',    '',    '1',      '1000', 
'1',   'B  ',          '',    '',  '');commit;
'

--> .... columns are duplicate (that's normal because the data is already 
in there & the index are set on each field).

Then I redo the exact same insert:

10:34:00: Transition: 'BEGIN ON CONFLICT FAIL;
INSERT INTO Address (CustomerID, Name1, Name2, Name3, Address, ZIP, City, 
CountryCode, Phone, Fax, Remark) 
VALUES            ('1',         '1',    '',    '',    '1',      '1000', 
'1',   'B  ',          '',    '',  '');commit;
'

--> "Cannot start a transaction within a transaction"

Ok, I do understand that you can't start a transaction in another 
transaction, but as far as I know I did open & close it only once for each 
query, right?
My best guess is that somewhere the transaction isn't closed (internally)...

How can I solve this problem?



Thx!



G00fy, (aka KaReL, aka Steven)

Main Webpage : http://komma.cjb.net
CQ Database  : http://lid.fragland.net/
ICQ #        : 35217584