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. Thanks, - Joe -- Joe Strout -- [EMAIL PROTECTED] Verified Express, LLC "Making the Internet a Better Place" http://www.verex.com/