PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEVWEBDEV e WINDEV Mobile

Inicio → WINDEV Mobile 2024 → getting crazy woth query on Android
getting crazy woth query on Android
Iniciado por VEGEboss, mar., 27 2019 3:14 PM - 1 resposta
Membro registado
88 mensagems
Publicado em março, 27 2019 - 3:14 PM
ok folks, I need your help, because this is too much for my shoulders

I have this definition in the global declaration of the project

gCombo_Clienti is SQL Query =
[
SELECT DISTINCT
db_Vendite.ANDESCRI AS ANDESCRI
FROM
db_Vendite
WHERE
db_Vendite.MVCODESE >= {ParamMVCODESE}
ORDER BY
ANDESCRI ASC
]


and later, in the code of the main Window...

// I use a simple (and suggested by PCSOFT) assignment for parameters, like this
gCombo_Clienti.ParamMVCODESE = "2019"

// query execution
HExecuteQuery ( gCombo_Clienti, hQueryDefault )

// …and just to check
Info(gCombo_Clienti.ParamMVCODESE)


where is the problem?

when I run this in the WM environment Everything is fine and I have my data, but when I deploy the app on my tablet… nothing happens and the last line shows me and empty dialog with [ok]

please help me
Membro registado
514 mensagems
Publicado em março, 27 2019 - 5:30 PM
Hi VEGEboss

Try using HExecuteSQLQuery()

Source:
https://help.windev.com/en-US/…

let me know if it works.

Sometimes I tried to use parameters writing on my data source on a string, but I couldn't make it work, hope you could get it.

--
Best Regards
ARV