Home » Developing U++ » U++ Developers corner » SetOrderBy ABS
Re: SetOrderBy ABS [message #38763 is a reply to message #38762] |
Tue, 15 January 2013 10:47 |
|
ercu wrote on Tue, 15 January 2013 10:16 | Title("Artikelen");;
lijst.SetTable(ARTIKEL);
lijst.AddKey(A_ID);
lijst.AddColumn(A_CODE, "Code");
lijst.AddColumn(A_NAAM, "Naam");
lijst.AddColumn(A_SUBGROEP, "Groep");
lijst.AddColumn(A_PRIJS, "Prijs").SetConvert(GeldIntConvert(1));
//lijst.SetOrderBy(A_CODE);
//////////////////////////////
How can i sort the table with ABS like in mysql?
mysql query example: "ORDER BY ABS(track) DESC ".
|
Hi ercu,
Welcome to the forum
I'm not very familiar with SqlCtrl, but I believe you could make it work if you use SetOrderBy(SqlFunc('abs', A_CODE)) or something like that.
Best regards,
Honza
|
|
|
Goto Forum:
Current Time: Tue May 21 19:21:08 CEST 2024
Total time taken to generate the page: 0.01515 seconds
|