General information
Category:
Coding, syntax & commands
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only