denys wrote:
Hi all,I'm trying to create a table but I always get an "assertion failed" crash :-(Here is the statement:CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original INTEGER, used INTEGER, picture TEXT, note INTEGER, comment BLOB, note INTEGER, type INTEGER, idSpec INTEGER);
Maybe a bug in an older version of Sqlite coupled with the fact you are specifying the 'note' field twice in the above create.
Lawrence