[Tutor] sqlite3 COMMIT directive

[Dominik George]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Hi,

>sqlite3.OperationalError: cannot commit - no transaction is active

That means that you have to execute "BEGIN TRANSACTION" before using atomic commits.

http://www.sqlite.org/lang_transaction.html
http://sqlite.org/transactional.html

>I've been reading about the COMMIT directive but apart from its
>relationship with ROLLBACK, I haven't been able to figure out how it is
>
>relevant to my problem here.

It isn't. What is relevant is whether you use transactions or not.

- -nik
-----BEGIN PGP SIGNATURE-----
Version: APG v1.0.8-fdroid

iQFNBAEBCgA3BQJSSl6rMBxEb21pbmlrIEdlb3JnZSAobW9iaWxlIGtleSkgPG5p
a0BuYXR1cmFsbmV0LmRlPgAKCRAvLbGk0zMOJSUPB/9bNtMNiXOf+k8mrVRr6+NC
XBVMcSrXHIKbdojYthPNF7kT5DjVoEzvHPIwL01b+V7metjTA58FUGbE2CHP+0Ho
Ydr60MlXt5VhqOYLHy7KF3nZ6mkutcLGhSJzncdhYeYZG9QSk3W1Z7/eyPLs3Pzk
77Y6NjF/b7R47ey4dXfalJbkE2TGyVVixPzVaLutXIIPqXQdLracqlPa/jen0esK
j210UjCkMY/stlqEG0ADLX0PlNvyVYxuB/t70mRegj8GqX4txtOMDlJaasNJavkT
J2niBAw3ftW04qpJjJgnvdxTnw0YgW7+rqhm6/1gvLsPopnKStYp3NAFvXuidI1U
=L3tk
-----END PGP SIGNATURE-----