>>>>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
OOPS!! .... USE advertisers IN 0
Matt McDonnell
...building a better mousetrap with moldy cheese...