On Fri, 14 Jul 2006 16:37:49 -0600, you wrote: >On Jul 14, 2006, at 22:22 UTC, Will Leshner wrote: > >> COMMIT should write the data to disk. Did you check errors after the >> COMMIT to be sure there wasn't some kind of error? > >Yes, I checked, no error was ever reported. Also, I very clearly had all my >data accessible while the app was running, but after killing and restarting >it, the last two days' worth was gone. (Two days is roughly how long it had >been since the last time I started the app, though I can't be precise about >that.) > >If it matters, I'm using this in REALbasic, and doing the commit via the >db.Commit method. I could try instead doing db.SQLExecute "COMMIT", though I >would expect these to be equivalent.
How many SQL commands are in your typical transaction? Do you start them with a "BEGIN" ? If you never do a "BEGIN", every SQL command is one transaction, and "COMMIT" has no meaning. http://www.sqlite.org/lang_transaction.html >Thanks, >- Joe -- ( Kees Nuyt; Rotterdam; NL ) c[_] The motto should be : "It Just Wroks." Then a few years later they can issue a patch. (Ruben van der Leij)
