Thanks for the response. In the solution you propose, the view is no longer a
parameterized view. I asume you suggest putting the select statement with the
paramterized where clause in the code. In my question, I simplified the query.
In reality, it is a huge query (view with left join to two sub-views). I prefer
to avoid embedded that SQL complexity into my code. A parameterized view allows
me to do that just fine in other SQL engines, but apparently not SQLite.
> From: petite.abei...@gmail.com
> Date: Thu, 22 Dec 2011 00:00:30 +0100
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Parameters are not allowed in views
>
>
> On Dec 21, 2011, at 11:40 PM, Chris Mets wrote:
>
> > Is this truly a limitation of SQLite or am I doing something wrong?
>
> The later. Simply create your view. Then restrict it.
>
> In other words:
>
> create view foo as select bar from baz
>
> select * from foo where bar = ?
>
> _______________________________________________
> 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