added view overrides, added update sql, fixed a tree bug