Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GROUP BY 1 no longer works
Message
From
16/02/2003 20:06:09
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00750415
Message ID:
00753948
Views:
24
>>Conforming to standards is fine, to a point. At that point, Set ... 70 would be my choice.
>
>Conforming to standards is "byproduct" of changes made in VFP8. The main reason for those changes in VFP8 was that those queries (DISTINCT with memo and GROUP BY with fields not included in the GROUP BY) returned incorrect results in previous version of VFP. That explains why it wasn't implemented in any other DB.

Then I'm just lucky that this didn't bite me before. Or if it did, that nobody noticed ;).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform