>I think you will find that the SQL is compiled and run when the view is queried- this is why a view's SQL property is readonly. The only action that can give this property a new value is CREATE SQL VIEW. This is just conjecture...
Wait- that came out wrong. I meant I think you will find that views are compiled when created, not when queried.
Erik Moore
Clientelligence