>I didn't blindly do anything!
>
Using a feature without understanding how does it work sounds pretty blindly to me. If you wouldn't rely on some magic REQUERY for referenced views, you wouldn't have this problem with your app and we wouldn't have this conversation.

>And I did not execute a view a FROM (if you would have read my original post).
>

Here is the query from your original post:

CREATE SQL VIEW "VTable1" AS ;
SELECT * FROM tabledatabase!Table1
LEFT JOIN viewdatabase!View1 ON View1.Id = Table1.Id
LEFT JOIN viewdatabase!View2 ON View1.Id = View2.Id

I see a couple of Views in the FROM clause. BTW, I didn't say "execute", I said "use".

>>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.
>>