When using the batch version of Execute (i.e. Iters>1) with SQLite, this command fails when being used within a transaction:
"cannot start a transaction within a transaction"
Oberserved behavior: Obviously, Execute tries to create a new transaction.
Expected behavior: If a transaction is already active, it should be used and only a Savepoint should be created.
SQLite: Batch Execute fails if within a transaction
Re: SQLite: Batch Execute fails if within a transaction
May I kindly ask whether I'm doing something wrong or this is a bug in the implementation?
Re: SQLite: Batch Execute fails if within a transaction
UniDAC work as you describe: if the transaction is run by a user, then Savepoint is created. Please make sure that you are using the latest UniDAC 7.0.2. version.
Please make sure that the issue is reproduced on the latest UniDAC 7.0.2 version. If it is, please compose a small sample demonstrating the described behavior and send it using the contact form https://www.devart.com/company/contactform.html including scripts for creating database objects. Also, please specify the used IDE version.
Please make sure that the issue is reproduced on the latest UniDAC 7.0.2 version. If it is, please compose a small sample demonstrating the described behavior and send it using the contact form https://www.devart.com/company/contactform.html including scripts for creating database objects. Also, please specify the used IDE version.
Re: SQLite: Batch Execute fails if within a transaction
Ok, thank you very much for your information. I will check and create a small test program.
Re: SQLite: Batch Execute fails if within a transaction
When you get any results concerning this question, please let us know.