On 16 Jul 2011, at 4:56am, san long wrote: > 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.
Process B can see the VIEW until process A DROPs the VIEW. On 16 Jul 2011, at 5:01am, san long wrote: > sqlite3 support a trigger on SELECT ? View is a good solution, but I > want to let different process see different records, like: > pid A sees rowid 1,2 > pid B sees rowid 1,3 Is there another process that can see all three rows ? How are you deciding which rows each process can see ? Is it magic ? Are there keys stored somewhere ? Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
