I have been using SQLite in LC extensively for about a year on IDE PC/IDE Mac/Android/IOS. I have an SQLite app on the PlayStore also. I have not seen this type of problem. As far as I know there is no simple way to wipe data across multiple tables unless you do some SQL joins.
Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net -----Original Message----- From: use-livecode-boun...@lists.runrev.com [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of Dr. Hawkins Sent: Wednesday, October 03, 2012 12:35 PM To: How to use LiveCode Subject: Entire sqlite database wiped of data?? While working last night with my program, somehow, all three tables were wiped clean of data. The columns are still there, but the data is not. For that matter, the keys are still there, but the data for the other columns of each row was wiped. When I read the binary file, I can see the data there. Is there an sql command that can wipe multiple tables simultaneously??? Do I have an even bigger problem? -- Richard E. Hawkins, Esq. (702) 508-8462 _______________________________________________ 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 _______________________________________________ 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
