[sqlite] Better example of fk mismatch problem

I found where I was getting a 'foreign key mismatch' error, but I don't know why. There are 2 versions of the last table below. They look like they are about the same to me, but one causes the error. The error occurs when I am doing a cascading delete in unrelated tables, and the problem table has

[sqlite] Sqlite3.exe command line tool - winXP

I have been trying to (without much joy) get a list of rows from a table within an sqlite3 DB. I've been starting from the CMD prompt sqite3 dropping into sqlite3 cmd prompt i type in sqlite> select * from accounts; SQL error: no such table: accounts sqlite> Now I've used SQLite Database ma

Re: [sqlite] Add IMMEDIATE/EXCLUSIVE support to SAVEPOINT?

"D. Richard Hipp" writes: > On Dec 4, 2009, at 9:45 PM, Nikolaus Rath wrote: >> >> Has it ever been discussed (or for good reason never been considered) >> to extent the SAVEPOINT command with respect to its behavior if there >> is no enclosing transaction? >> > > > http://www.sqlite.org/lang_save

Re: [sqlite] The point of BEGIN DEFERRED

Nikolaus Rath wrote: > Now I am wondering: in which situation do I actually want to use BEGIN > DEFERRED? For a read-only transaction, of course. Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailm