Re: [sqlite] Crash while creating a table

2005-10-08 Thread denys
Hi, Sorry for the long time, but I couldn't check my mails until today. Thanks to all your answers and explanations, and thanks Christian for the performance tip :-) As I just began my project (and also using sqlite), I appreciate a lot. Denys Christian Smith a écrit : On Sat, 1 Oct 2005,

Re: [sqlite] Crash while creating a table

2005-10-04 Thread Christian Smith
On Sat, 1 Oct 2005, denys wrote: >Hi all, > >I'm trying to create a table but I always get an "assertion failed" >crash :-( Addressed by others ... > >Here is the statement: >CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original >INTEGER, used INTEGER, picture TEXT, note

Re: [sqlite] Crash while creating a table

2005-10-01 Thread denys
G. Roderick Singleton a écrit : On Sat, 2005-10-01 at 22:19 +0200, 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,

Re: [sqlite] Crash while creating a table

2005-10-01 Thread drh
denys <[EMAIL PROTECTED]> wrote: > > 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); > > Assertion failed: pCol->zType==0, file

Re: [sqlite] Crash while creating a table

2005-10-01 Thread Lawrence Chitty
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

Re: [sqlite] Crash while creating a table

2005-10-01 Thread G. Roderick Singleton
On Sat, 2005-10-01 at 22:19 +0200, 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,

[sqlite] Crash while creating a table

2005-10-01 Thread denys
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);