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 hard drive and upgrading to Lion (which should be done as part of upgrade to 5.5 Livecode anyway) should solve it. So the answer is that the file system of MacOS can cause problems. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode