On Thu, 13 Feb 2014 21:40:53 +0100 Zsbán Ambrus <amb...@math.bme.hu> wrote:
> > I want the name of the country can not be changed. > > You can put all the tables you want to be not changable to a separate > database file which you attach as read-only. Use the ATTACH statement > with the URI filename syntax, as documented in > "http://sqlite.org/uri.html" , to attach the database as read-only. It occurs to me there's an even stronger (and more involved) solution. A virtual table (http://www.sqlite.org/vtab.html) could return values from any source, and prevent updates by setting xUpdate to NULL. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users