U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » OrderBy in descending order [ANSWER FOUND]

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

OrderBy in descending order [ANSWER FOUND] [message #5054]

Fri, 01 September 2006 15:39

zsolt
Messages: 697
Registered: December 2005
Location: Budapest, Hungary

Contributor

Hi, is it possible to create a SELECT with "ORDER BY FIELDNAME DESC" using an explession like this?
sql * Select(FIELDNAME).From(TABLENAME).OrderBy(FIELDNAME);

[Updated on: Fri, 01 September 2006 15:47]

Report message to a moderator

Re: OrderBy in descending order [message #5055 is a reply to message #5054]

Fri, 01 September 2006 15:45

zsolt
Messages: 697
Registered: December 2005
Location: Budapest, Hungary

Contributor

Sorry for the above question, I found Descending() function Smile

Report message to a moderator

Re: OrderBy in descending order [message #5059 is a reply to message #5055]

Fri, 01 September 2006 18:28

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

Yep, there is no "postfix function syntax" in C++ Smile

Mirek

Report message to a moderator

Re: OrderBy in descending order [message #13146 is a reply to message #5059]

Sun, 16 December 2007 17:32

lokki
Messages: 20
Registered: November 2005

Promising Member

A bit curious about this. Why not to implement a function like OrderByDesc(const SqlSet& set) ?

It is a little hack to Core and I've found it already useful (when doing background data modifications in DB without GridCtrl or any other "viewer" involved)

Thanks for answer.

Report message to a moderator

Re: OrderBy in descending order [message #13335 is a reply to message #13146]

Wed, 02 January 2008 09:03

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

lokki wrote on Sun, 16 December 2007 11:32

What should it do?

Mirek

Report message to a moderator

Re: OrderBy in descending order [message #13337 is a reply to message #13335]

Wed, 02 January 2008 11:22

lokki
Messages: 20
Registered: November 2005

Promising Member

It should fetch results in descending order

SELECT COL1, COL2 FROM SOME_TABLE ORDER BY COL2 DESC

Report message to a moderator

Re: OrderBy in descending order [message #13338 is a reply to message #13337]

Wed, 02 January 2008 11:51

unodgs
Messages: 1366
Registered: November 2005
Location: Poland

Ultimate Contributor

From HomeBudget:

        SQL & ::Select(NAME, SqlId("sum(value) as val"))
            .From(MONEY, CATEGORIES)
            .Where(DT_ID == dtid && CAT_ID == ID.Of(CATEGORIES) && PM.Of(MONEY) < 0)
            .GroupBy(CAT_ID)
            .OrderBy(Descending(SqlId("val")));

Just add Descending to OrderBy

Report message to a moderator

Re: OrderBy in descending order [message #13339 is a reply to message #13338]

Wed, 02 January 2008 11:53

unodgs
Messages: 1366
Registered: November 2005
Location: Poland

Ultimate Contributor

Oops I overlooked answers above Smile

Report message to a moderator

Re: OrderBy in descending order [message #13340 is a reply to message #13339]

Wed, 02 January 2008 11:56

unodgs
Messages: 1366
Registered: November 2005
Location: Poland

Ultimate Contributor

I think we could provide OrderByAsc and OrderByDesc (Dsc). It's more natural (from C++ point) than Descending (which it's more correct looking at SQL syntax)

Report message to a moderator

Previous Topic:	How to use Clipboard in HomeBudget(SqLite3)?
Next Topic:	XML Parser has no support for DTD

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Apr 26 10:51:11 CEST 2024

Total time taken to generate the page: 0.05847 seconds