SQLite SQLite column can't be updated to any value but zero (real type)
- by user1065320
Hi I'm trying to create a three fields table (date,text,real),
I can insert and update the first two fields but can't set or update the last one.
createSQL = @"CREATE TABLE IF NOT EXISTS ACTIVITIES (MYDATE DATETIME PRIMARY KEY, ACTIVITY TEXT , LENGTH REAL);";
try to insert
char *update = "INSERT OR REPLACE INTO ACTIVITIES (MYDATE, ACTIVITY ,…
