Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL GROUP BY with MEMO-Field in Fieldlist
Message
From
15/11/2013 20:20:43
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01587998
Message ID:
01588129
Views:
58
>>
>If the information in the memo is less than 254 characters, then you can use these 254 chars and use distinct. Otherwise there is no way without a primary key.

Coming in late and realizing that in another thread you argued for the cleaner solution of a PK: "No Way" is simply not true. Hashing is typically used in such situations.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform