On 16 Jul 2016, at 11:54, Hilaire <hilaire@drgeo.eu> wrote:
Hi Sven,
I know but my questioning is how you will do it properly with Pharo driver for Sqlite. In my previous email, I shared how I think doing it but I am not sure it is the proper way.
Ah yes, I didn't read all the way through.
For example, NBSqlite3ResultSet (specific to Pharo driver) produces rows on demand, is such instance valid once you commit the transaction? Or should you request it before or the transaction end?
I think I would first try to get the result inside the transaction. If the commit fails, it would be invalid of course.
Thanks
Hilaire
Le 16/07/2016 16:07, Sven Van Caekenberghe a écrit :
That are SQL 101 questions, this is a Pharo list ;-)
You should wrap your SQL statements in a transactions, https://sqlite.org/lang_transaction.html
-- Dr. Geo http://drgeo.eu