failed to alter table

[melamoud]

Hi guys,
I'm trying to add a timestamp column and it wont let me,
the code is simple

SQL1.ExecNonQuery("ALTER TABLE alerts ADD COLUMN added_on TIMESTAMP NOT NULL DEFAULT current_timestamp")

the error is

16:42:54 MNot:Failed to Upgrade DB to 0.92(92):(SQLiteException) android.database.sqlite.SQLiteException: Cannot add a column with non-constant default: ALTER TABLE alerts ADD COLUMN added_on TIMESTAMP NOT NULL DEFAULT current_timestamp

is it not possible to add an automatic timestamp column ?

any other trick ?

thanks

 

[melamoud]

found this SQLite Query Language: ALTER TABLE

which explain why it is not allowed , anyone can think of a work around (apart from copying the table to a temp table, drop it recreate it and copy back) - ouch!

 

[Erel]

You can set the current time yourself...