On Wednesday, May 30, 2012 2:02:39 e.h. Igor Tandetnik wrote: > How about this. You create two views, say V1 and V2, one with the join > and one without. Take user-provided query, replace all occurences of V1 > with V2, and try to prepare the new query. If that succeeds, the new > query is syntactically well-formed and you can execute it. Otherwise, > fall back to running the original query.
That's a great idea! As there's a bunch of joins, I'd need to find the right permutation to reduce the number of joins. But that shouldn't take too long. Charles _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
