>>>I have been trying to upgrade my VFP3 app to VFP5. There is a problem with three-table SQL query, which works fine and fast with VFP3, but VFP5 starts building an endless .TMP file (until hard disk is full.)
>>>
>>>Anyone seen the same? Any workarounds?
>>>Thanks
>>
>>Please post the SQL statement. I'd be happy to give it a whirl, as, I'm sure, would others.
>>
>
>This is my test program:
>
>Close data all
>Open data data\Y1997
>Open data Data\VfpRefs
>
>
>Select Price,ProdName,AdvName;
> from Y1997!Y1997,VFPREFS!PRODUCTS,VfpRefs!Advertisers;
> Where Y1997.Product=Products.Product and Products.Adv = Advertisers.Adv and Products.Pg=1501;
> Into cursor Temp3
>
>- It works with my full VFP5 intallation, but not with a runtime installation.

This is my suggestion: Open all the tables prior to issuing the SQL statement

CLOSE DATA ALL
OPEN DATA data\Y1997
USE y1997
OPEN DATA Data\VfpRefs
USE products IN 0
USE advertisers

SELECT y.Price, p.ProdName, a.AdvName ;
  FROM y1997 y, products p, advertisers a ;
  WHERE y.Product=p.Product AND p.Adv = a.Adv AND p.Pg=1501 ;
  INTO CURSOR temp3

Obviously, I've made an assumption about where price comes from, but you get the picture.

HTH