hi all,
we are using sqlite on the iPhone, in conjunction with SQLCipher, so
the sqlite version is compiled in with SQLCipher. the version of sqlite is
3.7.2, and 4.3 of iOS.
i have an issue that suddenly started appearing all of a sudden. what
is happening is that the data is inserted into the database, but a read of the
database is returning empty rows. it's returning the correct number of rows,
and there is no error, but all columns in the row and empty strings.
if i then shut down the app and restart it, the data is retrieved with
no issues.
so basically a connection is made to the database, the table is created
if it doesn't exist, we go through a loop of processing JSON data read from the
web and inserting it row by row, then close the connection to the database. if
i immediately make another connection, the rows come back empty.
after the last insertion, i put a breakpoint and checked with an
external tool, and i can see all of my data in the database. but while the app
is running, the rows all return empty.
i've tried a number of things from wrapping the inserts into
transactions, opening and closing the db connection on each insert, and nothing
makes any difference. this problem just popped up, after working for a long
time, so i'm about to start going back in the revision history to see if i can
get a working copy. the work on the project has not been in this area, so it
is confusing.
any thoughts or ideas?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
