haha, if I CREATE VIEW in process A and DROP VIEW when A dies. Process B could see this VIEW or not? A and B run at the same thime.
2011/7/16, Simon Slavin <slav...@bigfraud.org>: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users