On 23 Sep 2010, at 2:59pm, Andy Gibbs wrote: > It seems to be a trade-off -- either the complexity is in the DELETE > statement to keep the primary key table tidy or in the SELECT statement > querying it. If it has to be a choice, then the complexity has to be in the > DELETE statement since this happens very infrequently.
Hmm. Yes, I think so. Some part of your code somewhere has to list all the secondary tables, and you already have it in the least annoying place. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users