>>I admit I'm a laggard here, not using p-views. Each query, in the case in point, might refer to different source tables with wildly different search conditions. You can set up a p-view using &sqlstr though can't you?
>
>You can try. I didn't :)
>
>Actually, trying that animal out may solve some mysteries on the issue of views - like "is the SQL string of a view re-evaluated each time or is it stored compiled" and "if compiled, does an embedded macro force re-evaluation at requery"...
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...
Erik Moore
Clientelligence