PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV Mobile 2024 → [WM20] having problems to creating an update with select
[WM20] having problems to creating an update with select
Débuté par J1517, 24 nov. 2017 22:10 - 1 réponse
Posté le 24 novembre 2017 - 22:10
Hello

I´m using windev mobile 20 and I want to use an update with a subquery (select), windev with HFSQL doesn´t work with that type of query, anyone has even do that on windev mobile before?

thanks.
Posté le 25 novembre 2017 - 13:14
Hi,

Do your subquery as a main query to find all your records, then a loop
with a hmodify, and you are all done. This will work everywhere (mobile
or not)

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

Ready for you: WXShowroom.com, WXReplication (open source) and now WXEDM
(open source)

More information on http://www.fabriceharari.com


Le 11/24/2017 à 4:10 PM, J1517 a écrit :
Hello

I´m using windev mobile 20 and I want to use an update with a subquery
(select), windev with HFSQL doesn´t work with that type of query, anyone
has even do that on windev mobile before?

thanks.