On 6/30/2011 1:15 PM, Simon Gornall wrote: > Is it possible to get the columns operated on by a WHERE clause from the > sqlite3_stmt once it's been prepared ? > > I looked at the sqlite3_set_authorizer, but it doesn't seem to have > an action code for examining WHERE - the only codes that use > column/table info are UPDATE (which I already know) and READ (I don't > know what this is used for but it sounds more general than I'd > need).
READ action gives you the columns that the statement needs to read, for any reason. They may be mentioned in SELECT, WHERE, ORDER BY, LIMIT, ON and other clauses - whenever an expression is allowed by the syntax. Seems to be just what you need. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users