Hi I'm using the finisar wrapper for sqlite in .net 1.1. However I have some problems with transactions. I'm using the same connection to fire all my selects, deletes and updates, but not necessarily the same thread.
When i start a transaction using "begin transaction" do some deletes and then tries to commit the transaction using "commit transaction" I get the following error most of the time: cannot commit transaction - SQL statements in progress. What are the causes for this behaviour. I do not have any pending statements and I call close on my readers. Any suggestions are welcomed. Thanks, Niels