[sqlite] PATCH: compound (multi-row) INSERT statements

The attached patch implements the compound (multi-row) INSERT statement syntax against the SQLite 3.5.1 source tree. Both named and unnamed INSERT column syntax with DEFAULT column values are supported. The patch transforms multi-row INSERT statements into compound SELECT statements separated by

[sqlite] SQL logic error or missing database

Hey all, i've an SQLite 3 database coming from a mobile phone (e2831) which works well on the phone itself : BEGIN TRANSACTION; CREATE TABLE devicephonebook( UID INTEGER PRIMARY KEY AUTOINCREMENT ,lastName TEXT NOT NULL DEFAULT(''),firstName TEXT NOT NULL DEFAULT(''), lastChar INTEGER

Re: [sqlite] sqlite3_exec function error:database is locked

Are you using any BLOBs in your table?. More often than not it will be your query which will have direct impact on the performance. I suggest you to check that appropriate columns have been indexed and are used in right manner as specified in the SQLite documentation or mailing list with subject "