>
>Dan,
>
>Thanks for your note. (For a while I thought I was going to win the award for the "longest-posting-never-replied-to" on UT .)
>
>I agree with all the things you say. Creating a presistent relationship first seems to help the view designer get it right.
>
>Also, be sure to try enabling SQL ShowPlan with the "11" parameter to have vfp show you the joins being used the the SQL optimizer:
>
> Type SYS(3054,11) in the command window to enable SQL ShowPlan
>
>VFP will then show you the "mistake" being made by the View Designer.
>
>As I think I mentioned, these "features" of the View Designer were mentioned in at least one presentation at DevCon.
>
>Best regards,
>
>Steve
Steve - thanks for the tip about the SQL ShowPlan. I wasn't able to get to DevCon this year. Hopefully the next. We're still waiting on our copies of the session notes.
Cheers - Dan LeClair
He who knows not and knows not he knows not, he is a fool, shun him.
He who knows not but knows he knows not, he is simple, teach him.
He who knows, but knows not he knows, he is asleep, wake him.
He who knows and knows he knows, He is wise, follow him.