Re: [sqlite] Transactions

On Sun, Feb 05, 2017 at 09:41:48AM +0100, Michele Pradella wrote: > Do you think transactions are useful only when you have to do a sequence > of statements that depends on each other and you need a way to rollback > all statements if something goes wrong? or you can use transactions even > with

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

On Tue, Jan 31, 2017 at 11:48:10AM -0500, James K. Lowden wrote: > On Mon, 30 Jan 2017 13:32:46 -0700 > Scott Robison wrote: > > > Basing source on "ANSI C" (as much as possible) just gives you the > > biggest possible distribution / compatibility. > > Yes, but it also

Re: [sqlite] How do I check if the DB is open?

On Tue, Dec 13, 2016 at 08:20:44PM -0500, Igor Korot wrote: > > What more are you trying to find out? > > If I forget to finalize statement, I can use that sequence to find > which query is dangling. > > So are you saying that this code should be executed if sqlite3_close() > didn't return

Re: [sqlite] How do I check if the DB is open?

I'm not sure exactly what you're trying to do, but if sqlite3_close() returns SQLITE_OK then it closed and if it returns SQLITE_BUSY then it's not closed but possibly in a messy state (my selects have default handling too but I think those are the only defined responses). If you know it