Erik,
I agree that it's strange, I was just pointing out that it theoretically could happen.
(BTW to be "proper SQL" you'd need to group on
all the fields from the parent table - I've been nipped by SQL Server a couple of times because I learnt my SQL from the lax fox!)
Cheers,
Andrew
>I suppose- if the field that you grouped on was the same as the foreign key, so there is no cross updating. Seems like a strange approach to me though-
>
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.