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