Cannot convert <type1> to <type2>

[felixbcastillo]

I had version 7.2.7 and everything worked fine...

Now after these new versions after 7.2.7 and using VirtualQuery, with no change, I get error:
"Cannot convert varChar to Currency"

I turned back to version 7.2.7 and everything works fine again...

[MaximG]

Please describe the issue in more detail. Compose and send us a small sample, the execution of which causes the issue. This is convenient to do using the e-support form ( https://www.devart.com/company/contactform.html )

[felixbcastillo]

Any news?

[MaximG]

We have reproduced the problem and fixed the bug. The fix will be included in the next UniDAC build. Currently, we can send you a night build of UniDAC with the fix. For this, please specify the exact version of Delphi you are using via the e-support form (https://www.devart.com/company/contactform.html)

[felixbcastillo]

Please send me the "night build" because I have downloaded the ones added recently and the problem persists...

[MaximG]

Please specify the exact version of Delphi and the license number you are using via the e-support form (https://www.devart.com/company/contactform.html)

[felixbcastillo]

I downloaded the recent files you sent links for and it still does not work!

Returning back to version 7.2.7

How bad...

[Stellar]

We sent you the night build of UniDAC. Please check whether there is this issue on the night build of UniDAC and let us know about the results.

[felixbcastillo]

Yes, there is an issue, the problem persists!

Steps:
1) Create a multi device application
2) Insert a VirtualTable and add 3 fields (string, currency, float) and open/activate it
3) Insert a VirtualQuery, link to the VirtualTable and the following SQL Text:
SELECT SUM(Field2) Field2, SUM(Field3) Field3 FROM VirtualTable1
*The resulting fields will be MEMOS (I do not understand why) so you have to convert them to currency

AND PUFF!!!!

or download a/my sample from:
https://mega.nz/#!FYk0CSzK!Zeg9gdjQNCwJ ... _DAYqSUrm8

Versions 7.2.7 (and previous) work fine
Versions 7.3.8 (and over) fail

[Stellar]

We sent you an email with the link to download the night build of UniDAC from 19.08.2018 (unidac73d25pro_19_08_2018.exe) where the issue with type conversion is fixed. When using the night build of UniDAC from 19.08.2018, you sample is working without errors.
Probably, you installed an earlier version of UniDAC. To solve the problem, try to perform the following steps:
- close Delphi;
- uninstall UniDAC;
- install UniDAC from the distribution unidac73d25pro_19_08_2018.exe;
Please follow our recommendations and inform us about the result.

[felixbcastillo]

I followed your steps and the problem still persists...

Unsupported data type mapping: "String" to "Currency".

[Stellar]

Thank you for the information. We have fixed the issue, and the fix will be included in the next UniDAC build.
In the shortest time, we will send you the night build of UniDAC.

[ertank]

Thank you for the information. We have fixed the issue, and the fix will be included in the next UniDAC build.

Hello,

Is there any planned release date for next UniDAC version?

Thanks & regards,
Ertan

[felixbcastillo]

No reply
No estimate date
No night build

I will still be waiting, you have a nice service support and great components!
Please, just be on our side and understand us. Thank in advance!

[MaximG]

The links for downloading the night builds, which include the required changes were sent to your email