-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/15/2011 09:01 PM, 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
Add a column to the table for the process roles. Then they do something like: select * from table where role='B' ... Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk4hE38ACgkQmOOfHg372QS5uACgo3kDXm4pRmEmxe3Vr25Oo8yG xt4AnjPXz7Fq5iBbCqUIHkGhaoS3R0al =3xUP -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users