WD22 - Fatal Error

Hi all,
i have a thread to send email in silent mode.

It's ok an all my customers but only for 2 customers sometimes give this error:

Erreur à la ligne 29 du traitement Global procedure InvioMailInQueue.
Vous avez appelé la fonction HExecuteQuery.
Errore interno alla DLL WDHF.

**********************************************

----- Informations techniques -----

Appel WL :
Traitement de 'Global procedure InvioMailInQueue' (ProcessoSilente.InvioMailInQueue), ligne 29, thread 0
Fonction 'HExecuteQuery', syntaxe 2

Que s'est-il passé ?
Errore interno alla DLL WDHF.

Code erreur : 72326
Niveau : erreur fatale

Dump de l'erreur du module 'wd240hf64.dll' (24.0.72.0).
Identifiant des informations détaillées (.err) : 72326
Informations de débogage :
##InternalError##
Fonction (7,56)
Informations supplémentaires :
EIT_PILEWL :
Global procedure InvioMailInQueue (ProcessoSilente.InvioMailInQueue), ligne 29
EIT_DATEHEURE : 24/05/2019 10:32:12
EIT_TYPE_WDFILE : <7>
EIT_IDCODE : <458752>
EIT_THREAD : <InvioMail>

At line 29 there is this HExecuteQuery:

IF HExecuteQuery(QRY_SelezionaMailDaInviare,WiNeMo_connection,hQueryWithoutCorrection,"'"+sKey_utente+"'","'"+AziendaInUso+"'",dDataOggi,TimeToString(tOraOggi,"HHMMSS")) THEN
...
END

The Variable sKey_utente, AziendaInUso, dDataOggi, tOraOggi are in "critical section".

Can you help me?

This kind of error is normally due to the windev's management of the queries.
You should imagine that a query is always global to the project. This issue also affects the "Data Source" variables (for example if you declare a "ds is data source" in a private procedure, and another "ds is data source" in another procedure, you cannot have both ds existing at the same time).


So, if you use a query in a thread, it may happen that another use of the same query give some unpredictable error…

In order to avoid this issue, you can use a SQL variable instead of the query. Something like:

 mySelezionaMailDaInviare is SQL Query =
[
//paste here SQL code (copy from the original query)
]

Hi,

the "internal HF dll error 72326" happens if you don't have a HyperFile context for a thread or another piece of code.

Kind regards,
Guenter Predl
office@windev.at