Re: [sqlite] Grabbing "default values" from the database...

The value has to be NULL for the default value to fire. If it's an empty string, "", that's what you'll get. StanD. - Original Message - Subject: [sqlite] Grabbing "default values" from the database... I'm working on a project in C# that u

[sqlite] Grabbing "default values" from the database...

I'm working on a project in C# that uses an SQLite database back-end. I have a table set up so that some columns have default values, such as: CREATE TABLE mc_question (id integer primary key autoincrement, q_type varchar(5) default "MC", single_multi bool, negative_score bool, cumulative_all bo