pcsoft.us.windevCopyright 2026, PC SOFT3 Aug 2015 07:14:00 Z3 Aug 2015 07:14:00 ZI doing a test to run a procedure in the thread. in main thread Info("start") M_cnt is int = 1 M_scnt is string LOOP (20) M_scnt = "cnt0" + NumToString(M_cnt) ThreadExecute(M_scnt, threadNormal, test) M_cnt++ Multitask(100) END Info("done") ------------------------------------------------------------------------------------- PROCEDURE test() m_sql is string = [ SELECT count(People_Name) FROM People ORDER BY People_Name LIMIT 4000; ] M_QRY is Data Source WHEN EXCEPTION IN IF SQLConnectWS(G_DB_WebService, G_DB_Server,G_DB_UID, G_DB_PWD, G_DB_Name, G_DB_Type) = 0 THEN ExceptionThrow(1,"Error SQLConnectWS (" + G_DB_WebService + ")" ) IF SQLExec(m_sql, M_QRY) = False THEN SQLInfo() Info("Error SQLExec " , SQL.MesError) ELSE END DO SQLInfo() Error( "Exception Occured : " + CR+ ExceptionInfo(), "Error code : " + SQL.Error , "Error Message : " + CR + SQL.MesError) END IF SQLReqExists(M_QRY) = True THEN SQLClose(M_QRY) SQLDisconnect() --------------------------------------------------------------------------------------------------------- here the log from webservice _ 20150803043323 AWWS wdsoapdb *ERROR* ERR_MSG_BOX 0 192.168.43.211 wdsoapdb Que s'est-il passé ? The query parameter was not found. Code erreur : 40089 Niveau : erreur non fatale (EL_ONRETURN) Dump de l'erreur du module 'wd200xml64.dll' (20.0.31.0). 0 _ 20150803043323 AWWS wdsoapdb *ERROR* ERR_MSG_BOX 0 192.168.43.211 wdsoapdb Que s'est-il passé ? The query parameter was not found. Code erreur : 40089 Niveau : erreur non fatale (EL_ONRETURN) Dump de l'erreur du module 'wd200xml64.dll' (20.0.31.0). 0 ---------------------------------------------------------------------------------------------------------- Summary after the test i discover , if without Multitask(100) after ThreadExecute() . this will generate fatal. but even with Multitask(100) , this is not bullet proof solution . when i run 10 times of the main thread, i get once fatal error . I try by set Multitask(200) . after that I don't get the error. how long multitask need to set ? my guess is depend your query .30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53360-wm20-android-threadexecute-and-webservice-not-stable/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)