Abroży Nieprzełoży wrote: > sqlite> PRAGMA writable_schema=1; The documentation says: **"Warning: misuse of this pragma can easily result in a corrupt database file."**
> sqlite> CREATE TABLE xqlite_sequence(name TEXT PRIMARY KEY, seq INTEGER) > WITHOUT ROWID; SQLite does not use SQL but raw VDBE commands update the row in the sqlite_sequence table (see autoIncBegin() and autoIncrementENd() in insert.c). Without the rowid, that code no longer works. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
