Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group by in a union clause error, (not the usual one)
Message
From
05/10/2005 12:51:53
 
 
To
04/10/2005 16:09:33
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01056034
Message ID:
01056354
Views:
16
The basic idea is to return the first item of every group of related items from a given table. So you need to determine which ones are first of a group, then get the entirety of those rows.


I'll give your construction a try, I'm not sure if VFP 9 will accept the implied grouping but its a good idea.
Sigfried Trent, aka FoxMan
(Working from his secret code cave, FoxMan battles the forces of darkness lead by the deranged and mysterious Bug Boy)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform