I'm not sure I understand your question, but the SQL statement in a view is executed when you USE or REQUERY() the view.

>I have an application which although runs locally accesses data from a server, I have a number of local views in my database, where are the stored SQL statements executed?
>TIA
>Pete Kane