Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GROUP BY 1 no longer works
Message
 
 
To
18/02/2003 17:18:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00750415
Message ID:
00754703
Views:
39
Jim,
>>
>
>So you are saying that the removal of memo allowability in DISTINCT select queries was a requirement to FIX the known bug?

Yes

>And you are saying that the need to now include ALL SELECTed fields in GROUP BY was a requirement to FIX the known bug?

Yes

>I don't think that either is the case, personally, but it is clear to me that at least the GROUP BY **can** be attributable to ANSI SQL compatability. I believe the both could have been fixed within the existing syntax - it's a simple matter of programming.

Nope, GROUP BY is bug fix also. Can you share your idea how it could fixed in another way?

>I agree that there were bugs and that they have fixed them. I don't feel that it was necessary to adopt ANSI IN ORDER TO FIX THEM.
>Now I don't object that ANSI compatibility was implemented TOO, because I think that is a good thing for the future.
>BUT it remains that I do not feel that the implementation we got was the optimal one. And it remains that we get what we get and have to live with it.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform