SQLite conundrum - Solved
james at thehales.id.au
Wed Dec 16 10:29:56 EST 2015
Luckily one cannot see your red face behind an email.
My app keeps master copies of the dbs I use and as a new book is added copies the master to the user's folder, renames it and proceeds to populate it.
It has been quite some time since I last read in a book as I have been editing the app using my initial book as my raw data.
I had recently made changes to this book and decided to read in the new version.
That is when my problem appeared.
After much testing of my routines I was ready to give up in despair when I noticed my master copy of the db was rather large. Some 13mb compared to the 18k it should have been.
Sure enough, although I had been copying and renaming my master copy, sometime in the last 10 months something changed in my code and I had populated the master copy instead of the renamed copy.
So when I looked to inspect the changes I had made in the book (yes, numbering paragraphs) I couldn't see them because I was looking in the wrong place. I was looking at the pre-existing data from the master copy, not the newly added stuff.
I still have the problem of populating the master, but at least that is no where near as serious as the problem I thought I had.
Something to engage with tomorrow.
More information about the Use-livecode