Re: SQLite odd behavior

Thanks Bill. It sure does sound like some weird OS X problem. I hope you like the program but unforunately most of the update features are disabled for the demo so it won't help in tracking down you problem I'm afraid. Pete lcSQL Software On Fri, May 11, 2012 at 12:32 PM

Re: SQLite odd behavior

Peter Your program is excellent! And it sees the missing data that SQLiteManager does not see. So it seems that there must be two copies of my SQLite database file on this mac, one of which is hidden. That's what my IT professional friend said was the only thing that made sense. So reformating har

Re: SQLite odd behavior

Peter I will download a copy of your program and install it on that old machine and see if there is any weird behavior though. I just went to your lcsql.comwebsite and downloaded the 30 day trial. I wanted to look at your program anyway as it sounds interesting. Bill On Fri, May 11, 2012 at 2:50

Re: SQLite odd behavior

I think it in a MacOS file behavior thing. The time I had the 3 month roll-back I noticed that another unrelated file in the same folder was missing. I looked for it all sorts of ways including with terminal. The next time I re-started the computer it returned. This is not the sort of behavior I'v

Re: SQLite odd behavior

Weird indeed. One possible explanation (except for the 3 months old thing) is that you are issuing a BEGIN statement, then doing some updates but not issuing a COMMIT statement when you're done. Those updates will only be visible to the specific data connection within Livecode that made the updat

Re: SQLite odd behavior

I know that's what I thought. There is no sqlite file anywhere near that file path and there are no SQLite files with the same name on this Mac. That would have been "too easy" of an answer it seems. On Fri, May 11, 2012 at 1:59 PM, Bob Sneidar wrote: > Hmmm... Sounds like you are opening a copy

Re: SQLite odd behavior

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

SQLite odd behavior

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 SQLiteMa