There is no sqlite single command to clear out all the data in all tables. If the keys are still there and you can see the data in binary mode then I'd guess something in your program is not working correctly. Try using one of the many sqlite admin tools out there to see if it sees the data.
Pete lcSQL Software <http://www.lcsql.com> On Wed, Oct 3, 2012 at 9:35 AM, Dr. Hawkins <doch...@gmail.com> wrote: > 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