|
| WM24 [Android] ORDER BY clause in Query |
| Iniciado por VEGEboss, jun., 25 2019 8:17 PM - Sem resposta |
| |
| | | |
|
| |
Membro registado
88 mensagems |
|
| Publicado em junho, 25 2019 - 8:17 PM |
hello folks
please consider this piece of code
gCount_Fatture is SQL Query =
[
SELECT DISTINCT
db_Vendite.MVCLADOC AS MVCLADOC,
db_Vendite.ANDESCRI AS ANDESCRI,
db_Vendite.MVCODESE AS MVCODESE,
COUNT(DISTINCT db_Vendite.MVNUMDOC) AS NUMDOC
FROM
db_Vendite
GROUP BY
db_Vendite.MVCLADOC,
db_Vendite.ANDESCRI,
db_Vendite.MVCODESE
ORDER BY
db_Vendite.MVCLADOC ASC,
db_Vendite.ANDESCRI ASC,
db_Vendite.MVCODESE DESC
]
when I use it with a simple HexecuteQuery everything is fine: number of records selected, data readed and so on
BUT...
the ORDER BY clause is NOT RESPECTED
this is what I need (screenshot from WDSQL Tool)
and this is the result at runtime (screenshot from Debugger)
as you can see the columns ANDESCRI and MVCODESE are totally ignored from the sort
Someone can help? |
| |
| |
| | | |
|
| | | | |
| | |
|