Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL GROUP BY with MEMO-Field in Fieldlist
Message
 
 
To
15/11/2013 13:50:02
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:
01588088
Views:
38
>>"very likely to be unique" always worries me. My experience is you eventually get in trouble.
>>
>
>True. And on an afterthought - I don't see why we cannot use a pk - valid for the lifetime of the query - using a derived table
>
>
>	select * ;
>		from ( select recno() as pk, ;
>				Test.* ;
>				from Test ;
>			) X
>
I know we can not use RECNO() when select uses more than 1 table. I haven't tested it with the derived table, but I think we need to have a real PK, each table should have a PK anyway.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform