Re: [sqlite] Default text column values

On Mon, 04 Aug 2008 12:47:24 +0100, you wrote: >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

[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.

Re: [sqlite] Default text column values

Are you sure? Send us yours commands that prove that. I wrote: 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, Sensor_Units VARCHAR(15)

Re: [sqlite] Default text column values

On Sat, 02 Aug 2008 13:51:15 +0100, you wrote: >Hi, > >I am using SQLite 3.6.0 under Windows. I created a table using the >following schema (prev used in another DB hence Varchars etc.) : > >CREATE TABLE CurrentValues ( > Time_Stamp DATETIME DEFAULT CURRENT_TIMESTAMP, > Sensor_ID WORD DEFAULT 1