Thanks for advice, delete or update the record in a view could affect the true table in sqlite now? And, if I create a view dynamically using sqlite3_exec, is it visible to other process who opens the same database?
2011/7/16 Simon Slavin <slav...@bigfraud.org> > > On 16 Jul 2011, at 2:19am, san long wrote: > > > I have an idea related to the safety of the records in a table: if it is > > possible to hide some records in a table so the upper user application > could > > not see them? > > You could CREATE a VIEW which selected just some rows of a TABLE. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
