System.Data.SQLite

The _typeNames in SQLiteConvert doesn't include support for "BOOLEAN".

Also, there seem to be some incompatibilities in the formats of some things like DATETIME fields with the product SQLite Expert.  (This may really be more of a feature request, but any help would be greatly appreciated). 

When the declared types in the database are compared to the list in _typeNames, it uses the String.StartsWith() comparison.  So anything that begins with "BOOL" is interpreted as a boolean type, including BOOLEAN.

As for the datetimes .. what format does SQLite Expert use?  I stick to the ISO8601 standard, which is what the official SQLite project recommends.

Robert

The reason I would like to use BOOLEAN is because SQLite Expert doesn't recognize that BOOL is a boolean value (with a nice checkbox column). It seemed like using the BOOLEAN type would cause a sqlite data adapter to throw a concurrency exception on doing an Update() after doing a SQLiteCommandBuilder.GetUpdateCommand(). The original values read into the dataset included the correct true/false value for bool, but the checked value included only false, returning no rows, thus the concurrency exception. (if that sounds confusing, it is for me too... this didn't work earlier with BOOLEAN and it did with BOOL... but after a quick test just now, it seems to be ok either way... strange, is there something that could have been changed to help this in 1.0.47.1?)

Actually... a new idea about that... this database was converted from Access, which uses -1 instead of 1 to represent TRUE. Does System.Data.SQLite always accept the value -1 in a BOOLEAN field as TRUE?

Anyway... the second seemed to be an issue of how SQLite Expert stores date-time values, but I can't test it at the moment (I can't get it to input any date-time value without crashing).

I'll reply back if I can get it to work.

Thanks!
Brandon