Re: Entire sqlite database wiped of data??

2012-10-08 Thread Dr. Hawkins
On Sat, Oct 6, 2012 at 10:53 AM, Peter Haworth wrote: > Did you execute the PRAGMA command? I don't know for sure but it's > possible it might fix some problems. I'm going to try tomorrow . . . right now I'm to groggy from bounding back and forth across the country--I made the first public showi

Re: Entire sqlite database wiped of data??

2012-10-08 Thread william humphrey
I had very similar stuff happen to my SQLite database when I updated my MAC/OS to 10.7 from 10.6 - I could see the data with my SQLite reader but LiveCode was not letting me see it. It was inconsistent too. Sometimes it would all come back. I finally decided that behavior was too flaky for me and

Re: Entire sqlite database wiped of data??

2012-10-08 Thread Bob Sneidar
QUICK!!! BACK IT UP! Bob On Oct 5, 2012, at 5:43 PM, Dr. Hawkins wrote: > On Fri, Oct 5, 2012 at 1:37 PM, Peter Haworth wrote: >> Is your database still in the corrupted state? If so issue the following >> command: >> >> PRAGMA integrity_check > > OK, this is getting bizarre. > > I rus

Re: Entire sqlite database wiped of data??

2012-10-06 Thread Peter Haworth
Did you execute the PRAGMA command? I don't know for sure but it's possible it might fix some problems. Pete lcSQL Software On Fri, Oct 5, 2012 at 5:43 PM, Dr. Hawkins wrote: > On Fri, Oct 5, 2012 at 1:37 PM, Peter Haworth wrote: > > Is your database still in the corru

Re: Entire sqlite database wiped of data??

2012-10-05 Thread Dr. Hawkins
On Fri, Oct 5, 2012 at 1:37 PM, Peter Haworth wrote: > Is your database still in the corrupted state? If so issue the following > command: > > PRAGMA integrity_check OK, this is getting bizarre. I rushed to try this, and all of my data is back. I can also see the data (and not just the keys) f

Re: Entire sqlite database wiped of data??

2012-10-05 Thread Peter Haworth
Is your database still in the corrupted state? If so issue the following command: PRAGMA integrity_check It will return either OK if it doesn't find any errors or a list of error messages. That won't discover exactly what caused the problem but it might point you in the right direction. In par

Re: Entire sqlite database wiped of data??

2012-10-05 Thread Dr. Hawkins
On Fri, Oct 5, 2012 at 1:26 PM, Bob Sneidar wrote: > Hmmm... my professional IT opinion is, the file became damaged somehow. > Certainly not unheard of in the SQL world! Thanks. My inclination is the same--every other explanation seems highly improbable, and then some . . . -- Richard E. Hawk

Re: Entire sqlite database wiped of data??

2012-10-05 Thread Bob Sneidar
Hmmm... my professional IT opinion is, the file became damaged somehow. Certainly not unheard of in the SQL world! Bob On Oct 5, 2012, at 12:59 PM, Dr. Hawkins wrote: > On Thu, Oct 4, 2012 at 8:43 AM, Bob Sneidar wrote: >> Richard, barring anything your app could have done to wipe the data,

Re: Entire sqlite database wiped of data??

2012-10-05 Thread Dr. Hawkins
On Thu, Oct 4, 2012 at 8:43 AM, Bob Sneidar wrote: > Richard, barring anything your app could have done to wipe the data, and > barring a damaged database file (a possibility if the >physical media took a hit) there is only one thing left. Someone hacked into >your database and altered the data.

Re: Entire sqlite database wiped of data??

2012-10-04 Thread Bob Sneidar
Richard, barring anything your app could have done to wipe the data, and barring a damaged database file (a possibility if the physical media took a hit) there is only one thing left. Someone hacked into your database and altered the data. How is your app accessing the data? Is the access to the

Re: Entire sqlite database wiped of data??

2012-10-03 Thread Dr. Hawkins
On Wed, Oct 3, 2012 at 9:49 AM, Bob Sneidar wrote: > I take it you have viewed the data in an SQL utility? Firefox has an sqLite > plugin that works pretty well and it's free. Without opening >your database myself, I can't do much to help. Unfortunately, it's client data. On Wed, Oct 3, 2012 at

Re: Entire sqlite database wiped of data??

2012-10-03 Thread Peter Haworth
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. Pet

RE: Entire SQLite database wiped of data??

2012-10-03 Thread Ralph DiMola
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 Dir

Re: Entire sqlite database wiped of data??

2012-10-03 Thread Bob Sneidar
I take it you have viewed the data in an SQL utility? Firefox has an sqLite plugin that works pretty well and it's free. Without opening your database myself, I can't do much to help. Bob On Oct 3, 2012, at 9:35 AM, Dr. Hawkins wrote: > While working last night with my program, somehow, all

Re: Entire sqlite database wiped of data??

2012-10-03 Thread Magicgate Software - Skip Kimpel
Yikes! Hopefully you have everything backed up! I am curious to hear of the possible causes of this... very scary scenario. SKIP On Wed, Oct 3, 2012 at 12:35 PM, Dr. Hawkins wrote: > While working last night with my program, somehow, all three tables > were wiped clean of data. The columns a