John Carey wrote:
[Lot's of stuff, in multiple, apparently redundant threads, cut as
irrelevant.]
If I go into the firefox add on and run a checkpoint , the 2 new invoices
get flushed from the WL to the db file and then my program sees them
what am I doing wrong where my script is only looking at the db file and not
the WAL file?
Before getting to your topic (as I guess at it), let me remind you that
posting the same question multiple times to a newsgroup or email list is
considered to be rude. If you post and get no reply, then, after a
reasonable amount of time, (which would be several hours or more), you
might review your earlier post for clarity and appropriate brevity, and
decide to post a revision calculated to improve the odds of getting a
useful response. But just sending essentially the same thing under
different subjects and names is more likely to reduce your chances.
I've omitted quoting most of your post(s) because it does not reach the
problem, which is that you are paying too much attention to the WAL
file. Except for the fact that SQLite, under some circumstances and
modes of usage, creates a WAL file, its content should be of no concern
to you unless you are improving or fixing SQLite itself. Other than
deciding whether you need SQLite to employ the WAL file (of its own
creation, normally), and making sure it can be created when needed, it
is not something you have to deal with. Only the file named in the
sqlite3_open*() call is persistent except under certain abnormal
termination conditions. (You may want to study what those are, but that
will not cure your present difficulty.)
I dare say that your puzzling query results would be the same if you
were to run SQLite so that it does not use a WAL file. Discovering
whether that is so is a worthwhile experiment, and if it is so, will
allow you to focus on your schema and query rather than details of
SQLite implementation that should be opaque to you as a user.
Best regards,
--
Larry Brasfield
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
