Hi Farouk
>If I have views in the DE and have set the NoDataUnload = .T. and ahs filter property set, will subsequent REQUERY uses the filter to further filter the view. I know I can put extra parameters to filter the views but the developer who done the view has missed out this filter and there maybe many screens using the view. I thought of using the load method to further filter the view. Possible?
I am afraid that the short answer is NO. View definitions cannot be 'modified' at run time like this, the only option is to create the view definition 'on the fly' and run it.
What you are describing is an 'ad-hoc' query, that is to say one where the selection fields and joins are static, but different filter conditions are applied at run time. One of the major limitiations of Views is their inability to support such queries.
----
Regards
Andy Kramek