PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Initialising a value in a Query done in the WINDEV Query designer
Initialising a value in a Query done in the WINDEV Query designer
Iniciado por mthomas, 22,abr. 2020 17:11 - 1 respuesta
Publicado el 22,abril 2020 - 17:11
Hi folks,

Just upgraded from WINDEV 21 to WINDEV 24 and found that a piece of code which has had no problems since Version 18 of WINDEV has now started moaning.

All Im doing is initialising a WINDEV query value (Query created using the WINDEV query designer) with a value from SQL statement which has been fashioned by using HExecuteSQLQuery() into a DataSource.


The line of code which its moaning about is:-

QRY_Import_JobHeader.DeclarantFk = ldsTemp.DeclarantFk


This is the Error:-

Message: An element of '128-bit UUID' type cannot be converted to the 'ANSI string' type.
DateTime: 22/04/2020 16:07:09
Element: WIN_IMPORT_Entry.PROCEDURE.SetUserDefaults
Line: 52
Program Stack:
Local procedure SetUserDefaults (WIN_IMPORT_Entry.PROCEDURE.SetUserDefaults), line 52



Any help would be appreciated!

Thank you.
Publicado el 22,abril 2020 - 21:59
a new version of the compiler will be stricter than an older one and detect errors that were present before. This LOOKS like it is the case here...

The error says that your receiving parameter is an ansi string while the value you want to affect is a UUID... If the compiler is correct about that, than,as that kind of affectation is forbidden, we are in the case stated above and you need to correct your code and not rely on an automatic transformation...

Now, if the compiler is not correct and these two value are not as stated, then you can try and investigate why it is making a mistake on one of them