Hi Fabio,

Thank you for your response. 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.

I am going to be converting the backend to SQL Server soon anyway and all this will go away. Should have waited to upgrade to VFP9 until the SQL Server conversion was complete. Anyway, live and learn I guess.

Thanks again, Fabio for your response.

James


James Moore MCDBA, MCAD
President
Ministry Tracking Software, Inc.
james@youthtrack.com



>>Hi all,
>>
>>This phenomenon seemed to have just started after I upgraded to VFP9. Here is my situation. I have a view setup as follows:
>>
>>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
>>
>>If I perform the following:
>>
>>SELECT * FROM tabledatabase!vtable1
>>
>>All of the expected records are returned normally.
>>
>>However, if I open the view like this:
>>
>>
>>USE tabledatabase!vtable1 NODATA
>>.
>>.
>>.
>>REQUERY()
>>
>>No records are returned. However, if I requery the JOIN views first like the following:
>>
>>USE tabledatabase!vtable1 NODATA
>>.
>>.
>>.
>>IF USED('View1')
>> REQUERY('View1')
>>ENDIF
>>
>>IF USED('View2')
>> REQUERY('View2')
>>ENDIF
>>
>>SELECT vtable1
>>REQUERY()
>>
>>Then all of the records are turned as they should be. I know I tested this prior to VFP9 and I did not have to requery the JOINed views? Is this something new to VFP9 or is there some type of new VFP9 setting that can be set so I don't have to remember to go through and requery views that my be joined to a specified table in a local view such as the example I just illustrated?
>>
>>Any feedback would be greatly appreciated.
>>
>>Thanks,
>>
>>James Moore MCDBA, MCAD
>>President
>>Ministry Tracking Software, Inc.
>>james@youthtrack.com
>
>VFP9 doesn't requery the nested views.