System.Data.SQLite

I take it you are using ALTER TABLE which has some limitations.''The column may not have a default value of CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP.''

You might want to try SQLiteSpy instead, since ZeosLib encodes strings incorrectly anyway. I've only tested the string encoding though.DateTime strings have to be ISO 8601 formatted but you can insert an incorrectly formatted date only to discover the error at retrieval when the SQLite adapter tries to convert the string to a DateTime object.If ...

A very good point indeed. A feature limited to Debug builds? If at all.

Hi,I have some related thoughts. I upgraded from 1.0.29.0 to 1.0.31.0 and discovered that SQLiteDataReader now returns DBNull.Value instead of null if the column value in the database is NULL.I guess that's fine with SQLiteDataReader.GetValue() even if I prefer null, but SQLiteDataReader.GetString() will throw an InvalidCastException in ...

It's a nice program but be aware of that SQLite Admin uses the Delphi ZeosLib which incorrectly stores strings encoded as the current ANSI code page instead of UTF-8.SQLiteSpy stores strings correctly.

I second that request! Maybe add it to Exception.Data?

Some anti-virus programs are notorious for locking files. The slower the computer, the bigger the problem, in my experience. SQLite Check-in [3200] tries to solve the problem with locked journal files.

Try SQLiteSpy. Works at least with Swedish characters.

The Microsoft CLR Debugger included with Microsoft .NET Framework SDK v2.0 has both Threads and Call Stack windows. I think it's installed by default even with Visual Studio Express Edition.

You might want to have a look at SQLite ticket #1533 and maybe you can provide some input to the problem too.