<< While your wish #2 would be nice to have. I believe it would be a real technical challenge. RBase has no knowledge of VIEW dependences. Each VIEW would have to be analyzed and some for of dependancy list constructed.
>> I don't think that it would be that hard. R:Bases obviously can parse SQL to get the relation names that come after the "FROM" keyword in any SQL fragment. So if R:Base works it's way through the list of views with a DoUnload procedure that checks the list of dependencies, compares it with an internal list of already-unloaded views, and recursively calls itself to unload any necessary views before it unloads itself, you'd have it. I think I'm going to have a stab at doing it myself -- the only problems are parsing the FROM tables and the fact that you can't write recursive code in R:Base because of the lack of variable scope -- Larry
