Dave Dyer <[EMAIL PROTECTED]> wrote: > > > >SQLite thinks you have declared a column named "active" > >with a datatype of "BOOL JOINED DATE". > > Since BOOL JOINED DATE doesn't correspond to any known > data type, shouldn't it be flagged as an error? Surely > the declaration of a table shouldn't accept garbage. >
SQLite, by design, accepts any data type. Even those you might not have heard of before. This is a feature, not a bug. -- D. Richard Hipp <[EMAIL PROTECTED]>