>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.
About two months ago, a 'gentleman' (I'll use that term lightly.. ;-0) pointed out that VFP 5.0 does not support SQL statements as strongly as VFP 3.0. It appears that VFP 5.0 is much more sensitive to items being placed in the SQL statement in just the right order.
Matt McDonnell
...building a better mousetrap with moldy cheese...