On 16 Jul 2011, at 4:23am, san long wrote: > Thanks for advice, delete or update the record in a view could affect the > true table in sqlite now?
No. Either use the VIEW for SELECT and the TABLE for changes, or implement triggers so attempts to change your VIEW actually change the underlying TABLE. > And, if I create a view dynamically using sqlite3_exec, is it visible to > other process who opens the same database? Yes. A VIEW is a stored SELECT statement (or it has a similar effect). On 16 Jul 2011, at 4:25am, san long wrote: > right, but now I just want to hide these records to all processes. Then DELETE them ! Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
