I am seeing a behavior I cannot explain, I will try to keep things as
simple as possible.
I have a simple table that I use for storing phonebook entries (name,
phone number, etc). If I start fresh, I am able to Add/Remove/Retrieve
records with no problem from my database in memory.
My query to retrieve the records is using 'order by name' so that it is
sorted for me. I tried all kinds of sequence
Add-Retrieve-Add-Add-Retrieve-Retrieve-... and it never seemed to fail.
I store it in flash using:
"attach database pbook as pbook;"
"BEGIN;"
"create table if not exists pbook.phonebook as
select * from phonebook;"
"delete from pbook.phonebook;"
"insert into pbook.phonebook select * from
phonebook;"
"COMMIT;"
"detach database pbook"
and I recover it at boot time, using the following:
"create table phonebook as select * from
pbook.phonebook;"
AFTER I use the version from flash I seem to be unable to retrieve the
records using "order by" in my query, sqlite tells me "no such table" but
if I remove "order by" from my query, it works and I retrieve them
(unordered of course).
Any idea??
Mario Hebert
