Devart Forums

Hi,
I have installed latest 10.4.9 release of VirtualDAC.
Now every VirtualQuery (that works with previous release) give me "UNSUPPORTED DATA TYPE MAPPING "UNKNOWN(0)" TO "CURRENCY".
I need to upgrade because there are already a big bug in previuos releases (and I don't known if is already fixed): Virtual Query is closed if I close one of source dataset after quering!!! (other previous releases leave open virtualquery if I close all source dataset after query; this is the right way)

Please solve and update.

Thanks in advance.

Thank you for the information. Please describe the specified situation in more detail. For this, compose and send us a small sample, which when executed causes the UNSUPPORTED DATA TYPE MAPPING error. You can send this sample using the e-support form (https://www.devart.com/company/contactform.html)

Hi,
situation is very easy:
A TUniquery load a list of detail records (Firebird).
A VirtualQuery make sum of them with Group by (2 string fields, 3 currency fields). All mapping in VirtualQuery are right.
This Virtual is open after open TUniquery. With previous releases no error, with latest instead "unsupported data type mapping".
(Problem n. 2) Then need to close Tuniquery after open the VirtualQuery, because Tuniquery have a lot of records and because I have to open other sequential queries for "tuning" the virtual like lookups, etc, and need to save memory closing them after use, So i need to leave open only Virtualquery (at the end of all operation). With latest release, instead, VirtualQuery is closed.

I cannot send a small example (I can't send you all complex application with a big database...).
Thanks in advance.

Yes, it is broken.
I installed the previous version and it works.
I think there should be a new release to fix the problem ASAP.

Thank you.

I don't know if yesterday's release of VirtualDAC 10.4.10 was supposed to fix this, but I can confirm that it didn't.
The Issue is still there.

Hi,
after install of latest 10.4.10 error is changed; now I have: Unsupported data type mapping "Float" to "Currency".
Please fix with a new release,
(And don't forget to leave Virtualquery open even if I close one of its data sources)
Thanks in advance

Problem 1. Thank you for the information. We have reproduced the problem and fixed the bug. The fix will be included in the next VirtualDAC build. Currently, we can send you a night build of VirtualDAC with the fix. For this, please specify your license number and the exact version of Delphi you are using via the e-support form (https://www.devart.com/company/contactform.html)
Problem 2. You can leave VirtualQuery open after closing one of the datasets, which is one of its sources. For this, use the LocalUpdate property : VirtualQuery.LocalUpdate := True Note that in this case, any changes made to VirtualQuery will not be reflected in DB, the source of which was closed at that time.

Hi thanks,
Problem 1. If next virtualDAC build will be release in next days, i wait... otherwise I need a night build.
Problem2. Ok. I will try, It seems that in older release it worked in different manner.
Thanks a lot.

We will be able to send you a link for downloading a night build of our product. For this, please specify your license number and the exact version of Delphi you are using via the e-support form ( https://www.devart.com/company/contactform.html )

Hi,
after install latest night build I still have: Unsupported data type mapping "Float" to "Currency"...

Please compose and send us a small full 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)

Ok, I just uploaded a small sample project to illustrate the issue. I hope it gets resolved soon as it can be a real show stopper for some people.

Thank you.

Hi,
but bug is fixed and an update released?
I don't known! I still waiting for a solution (I haver stopped 2 projects)....

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

Night build 29 august....
This is my VirtualQuery :
'select sum(IVAIMPON) AS TOTIMPONIBILE,
sum(IVAIMPOS) AS TOTIMPOSTA,
sum(IVAIMPON+IVAIMPOS) AS TOTDOCUMENTO
from PNMovIVA;'

IVAIMPON,IVAIMPOS of PNMovIVA are Tfloat fields (Mariadb, MYSQL provider);
There are no records in PNMovIVA a design time.

If I don't assign data type mapping TOTIMPONIBILE, TOTIMPOSTA, TOTDOCUMENTO are Memo Fields....
If I assign them (data type mapping) to float or currency I have "Unsupported data type mapping: "VarChar" to "Float".