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 TAG_id = '54'; COMMIT; is executed by running `sqlite3_prepare_v2()` and the `sqlite3_stmt` returns `SQLITE_DONE`. So I consider the transaction made and closed. but if I looked in the db I still see the row/entry for 'loki' If I try (during the same process) to delete another tag, or if I try to delete the same tag again, the `sqlite3_stmt` returns an error, cannot start a transaction within a transaction I have the feeling I miss a command at some point. but I didn't found which one... (I can upload the code for further investigation if required.) regards, Nicolas J.
