SQLite odd behavior

[Bob Sneidar]

Hmmm... Sounds like you are opening a copy of the database in Livecode. 

Bob


On May 11, 2012, at 10:42 AM, william humphrey wrote:

> In case this ever happens to someone else... I have a SQLite database that
> I access with version 4.6.2 of livecode and now version 5.0. This Livecode
> database is behaving like it has a secret section which can be written to
> by LiveCode and read from by LiveCode but when you look at it with
> SQLiteManager you don't see those changes (you also don't see those changes
> when you look at it with vStudio).  Also, even more unpredictably,
> sometimes you can write changes to the SQLite database which even LiveCode
> in the same session can't see. You can add something to it with
> SQLiteManager and that change is always visible in all three programs. Also
> once I opened it up in LiveCode and it had rolled back to data three
> month's old. This behavior is beyond me to figure out and since that is my
> last stack that still uses SQLite I converted it to Valentina with the
> vStudio application from Valentina that converts databases and now I'm
> making many improvements in the stack which take advantage of Valentina's
> features not the least of which is vServer.
> 
> Anyway I'm not knowledgeable enough to figure out what's going on with
> SQLite and I'm now going to stay away from SQLite as that was a pretty
> scary data loss (of course I have back ups) in a working program in the
> middle of a job. I'm also moving forward to LiveCode 5.5 which drops some
> of the database query builder stuff I shouldn't have been using anyway.
> Maybe the SQLite behavior had something to do with the Mac I was working on
> version 10.6.8 so I upgraded that to  Lion. Since SQLite is basically just
> a simple text file this behavior is possibly something to do with MacOS and
> not LiveCode at all. I do my backups to drop box.
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode