The problem with the view is that you can not pass a parameter or variable from the outer select to the views select.
On Mon, Jun 30, 2008 at 12:49 AM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > "Henrik Bechmann" <[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] > > Thanks Igor! And the SQL statement can be bound to parameters in the > > usual ways? > > No, not in the view. You can, of course, select from the view (as if it > were a table), and _that_ query can be parameterized. > > Igor Tandetnik > > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
