>I wonder what genius over at on the VFP9 development team put this new "feature" into place? If I would have known this, I never would have "upgraded" from VFP8 to VFP9. SETENGINEBEHAVIOR makes no difference either, you have to be running VFP8 to get the old behavior where nested views are automatically requeried.
>
Hi James,

FYI, VFP never executed REQUERY for views a query is based on. Did you blindly rely on this in your app or did you simply not think about implications of using views in a FROM? What is changed in VFP9 is the way views are opened with NODATA, all other views the view is based on are opened with NODATA as well. You can read more about this in message #985777. If you'd like to know who made this change, that was me.

Thanks,
Aleksey.