On 6/30/2011 1:43 PM, Simon Gornall wrote: > Well, perhaps I'm missing something, but if the statement for which I'm > caching results was something like > > SELECT * FROM tableName WHERE columnName = zzz; > > I'd only want to clear the results cache when statements like: > > UPDATE tableName set columnName = xxx where id=yyy; > > were processed. I'd specifically *not* want to clear the results-cache for > the above statement when I got: > > UPDATE tableName set otherColumnName = xxx where id = yyy; > > ....because changing values in the column 'otherColumnName' can't affect the > results-list for a query only dependent on the column 'columnName'.
What do you mean, can't affect? The SELECT statement is returning the values from otherColumnName in the resultset. If changing those doesn't affect it, I don't know what does. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
