On Dec 23, 2011, at 2:31 PM, Chris Mets wrote: > A parameterized view allows me to do that just fine in other SQL engines,
Well, MSSQL sports so-called parameterized views, but that's about it. > but apparently not SQLite. If you insist on that approach, you could rewrite your view in term of a parameter table, as pointed out by Kees Nuyt somewhere else in this thread. So: (1) create temporary table parameter( value ) (2) create view foo as select bar from baz where bar = (select value from parameter) (3) insert into parameter( value ) values( 'fubar' ) (4) select * from foo Seems clumsy though. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
