See http://sqlite.mobigroup.ru/src/wiki?name=WClark
To use READONLY, it should form part of a constraint clause for the column. So, for example: CREATE TABLE t (i integer readonly); or CREATE TABLE t (i integer constraint my_constraint readonly); READONLY stops the value being modified through an UPDATE command. However, it does not stop an UPDATE OR REPLACE or an INSERT OR REPLACE where the row is deleted and a new one inserted. To stop this then the integer primary key must also be given the READONLY constraint. This will then stop the UPDATE OR REPLACE and INSERT OR REPLACE operations changing that row, as well as making the rowid readonly. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
