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 <[email protected]> > > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
