[sqlite] Default text column values

Thanks Emilio and Kees for doing what should have done - a bit of basic SQL! Well the problem has been narrowed down to the the Show Table/Modify Data function in SQLit3Manager. If I just do a simple insert from there the default text does not appear. The numeric defaults are ok however.

[sqlite] Default Column Values

I am using SQLite 3.6.0 under Windows. I created a table using the following schema: CREATE TABLE CurrentValues ( Time_Stamp DATETIME DEFAULT CURRENT_TIMESTAMP, Sensor_ID WORD DEFAULT 1 NOT NULL, Sensor_Name VARCHAR(20), Sensor_Type VARCHAR(8), Sensor_Value FLOAT DEFAULT 0 NOT NULL,