Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » OrderBy Descending missing
Re: OrderBy Descending missing [with fix] [message #21052 is a reply to message #21049] Tue, 28 April 2009 21:33 Go to previous messageGo to previous message
unodgs is currently offline  unodgs
Messages: 1366
Registered: November 2005
Location: Poland
Ultimate Contributor

Actually, I prefer OrderByDesc and SelectDistinct. The main reson is you can't write
Select(Disctinct(ID, NAME, AGE))

instead one must write
Select(Disctinct(SqlSet(ID, NAME, AGE)))

And what I like
SelectDisctinct(ID, NAME, AGE) //or
SelectUnique(ID, NAME, AGE)

Same story with Descending.
We could provide __Expand(SelectDistinct). Same should be done with OrderBy (OrderByDesc) and GroupBy. Now only three args can be passed.
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: sql example with 2 table needed
Next Topic: sqlite3 get number of occurrences
Goto Forum:
  


Current Time: Fri May 10 02:05:11 CEST 2024

Total time taken to generate the page: 0.02572 seconds