PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV Mobile 2024 → getting crazy woth query on Android
getting crazy woth query on Android
Débuté par VEGEboss, 27 mar. 2019 15:14 - 1 réponse
Membre enregistré
88 messages
Popularité : +2 (2 votes)
Posté le 27 mars 2019 - 15:14
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
Membre enregistré
498 messages
Popularité : +8 (8 votes)
Posté le 27 mars 2019 - 17:30
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