www.qxorm.com

QxORM offers two types of methods to sort columns: orderByAsc() and orderByDesc(). Unfortunately at least with SQLite you are not able to mix them since the ORDER BY SQL clause is generated twice.

e.g. query.OrderAsc(id).OrderDesc(Name) generates ORDER BY id ASC ORDER BY Name DESC.

Hello,

You can resolve this issue using the qx::QxSqlQuery::freeText() method (instead of OrderAsc or OrderDesc).

Example :

Code: Select all

query.freeText("ORDER BY XXXXXXXXX");

Yeah, I am using this work-around already .