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