On Fri, Dec 21, 2012 at 12:53 AM, Larry Brasfield <[email protected] > wrote:
> On 12/20/2012 4:10 PM, Larry Brasfield wrote: >> > Igor Tandetnik wrote: >> >>>> [regarding where parameters allowed, "where literals are"] >> >> > >> >> > How did you discern this? >> >> >> >> I know from experience where parameters work (SELECT, INSERT and >> >> similar; also ATTACH as one of my projects happens to use it this way), >> >> and where they don't (all forms of CREATE; I haven't tried ALTER but >> I'm >> >> 99% sure it won't work there either). I've just tested PRAGMA. I >> briefly >> >> scanned the rest at http://sqlite.org/lang.html to confirm that their >> >> syntax doesn't involve expressions. >> > >> > I do not mean to be argumentative here, but I think the documentation on >> > this leads to a different result. If you examine the syntax diagram for >> > "create view" >> >> Why should I? I never made any claim about CREATE VIEW's syntax. In my >> explanation, "All forms of CREATE", which includes CREATE VIEW, fall >> under "know from experience" bucket, not "syntax doesn't involve >> expressions" bucket. >> > > You assert (believably) that SQLite has not allowed parameters in views > for awhile, and that you know this from experience rather than the > documentation. I assert (without refutation) that the documentation > clearly allows parameters in a view. We have no disagreement, but it does > appear that SQLite's operation differs from what its documentation clearly > implies. Hence my revision of the topic. > > I will not suggest that you should be interested in this discrepancy, but > others might be. > > Best regards, > At least, there's this: http://sqlite.org/docsrc/info/7276f4a4a3e338ea187cb5e50c57e4f9806aed89?sbs=0 +ERROR_MSG {parameters are not allowed in views} { + The right-hand side of a CREATE VIEW (that is to say, + the SELECT statement that defines the view) may not contain + bound parameter names like "?", "?123", ":term", "@xyz", or "$var". +} -- -- -- --Ô¿Ô-- K e V i N _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
