[sqlite] I don't understand why I get "cannot start a transaction within a transaction"

2015-09-07 Thread Nicolas Jäger
Hi Simon and Stephan, Thx for your answers, I was very busy the last week and I worked on my program only saturday and yesterday. That's why I answering only today, but I wanted to thank you. I had some difficulties to use `sqlite_exec()` because I'm wrapping to C++ all Sqlite3 functions I need

[sqlite] I don't understand why I get "cannot start a transaction within a transaction"

2015-08-31 Thread Stephan Beal
On Mon, Aug 31, 2015 at 4:50 AM, Nicolas J?ger wrote: > I'm starting to use transaction in my C++ code to delete some entries > (tags) in my db. during execution, the first transaction (each > transaction is contained in one string), like : > > BEGIN TRANSACTION; > DELETE FROM TAGS WHERE NAME =

[sqlite] I don't understand why I get "cannot start a transaction within a transaction"

2015-08-31 Thread Simon Slavin
On 31 Aug 2015, at 2:23pm, Stephan Beal wrote: > Nope - you have only run the BEGIN part of the transaction. prepare() > prepares only one single statement, not multiples (you have 4 statements in > your SQL). Thus when you try to run another transaction, that BEGIN is > still open. In

[sqlite] I don't understand why I get "cannot start a transaction within a transaction"

2015-08-30 Thread Nicolas Jäger
Hi, I'm starting to use transaction in my C++ code to delete some entries (tags) in my db. during execution, the first transaction (each transaction is contained in one string), like : BEGIN TRANSACTION; DELETE FROM TAGS WHERE NAME = 'loki'; DELETE FROM TAGSMAP WHERE COLLECTION_ID = '3' AND