UNSUPPORTED DATA TYPE MAPPING!

Discussion of open issues, suggestions and bugs regarding Virtual Data Access Components for Delphi, C++Builder, Lazarus (and FPC)
Stefano Monterisi
Posts: 21
Joined: Wed 13 Dec 2017 15:11

Re: UNSUPPORTED DATA TYPE MAPPING!

Post by Stefano Monterisi » Thu 30 Aug 2018 09:44

Now I have removed VirtualDac and reinstalled the nightbuild release (trying with a new and fresh installation), but TVirtualQuery is disappeared (Delphi Tokyo)....

Stefano Monterisi
Posts: 21
Joined: Wed 13 Dec 2017 15:11

Re: UNSUPPORTED DATA TYPE MAPPING!

Post by Stefano Monterisi » Mon 03 Sep 2018 09:51

Hi,
Any news or hint? Workaround? A new night build?
I have to remove (all) devart components and reinstall older release?
Thanks,
Stefano

MaximG
Devart Team
Posts: 1095
Joined: Mon 06 Jul 2015 11:34

Re: UNSUPPORTED DATA TYPE MAPPING!

Post by MaximG » Mon 03 Sep 2018 13:56

We have not made any changes to UniDAC source code related to VirtualQuery behavior since we sent you the night build. We will try to understand the reasons for the unworkability of this build in your environment. Please explain whether you could correctly install the sent night build? Did you get any errors during its installation ? If the installation is successful, test the behavior of the night build using the following console application and tell us about the results :

Code: Select all

program Project1;

{$APPTYPE CONSOLE}

{$R *.res}

uses
  System.SysUtils, Data.DB, VirtualTable, VirtualQuery;

var
  VirtualTable: TVirtualTable;
  VirtualQuery: TVirtualQuery;
begin
  VirtualTable := TVirtualTable.Create(nil);
  try
    VirtualTable.FieldDefs.Add('Field1', ftFloat);
    VirtualTable.FieldDefs.Add('Field2', ftFloat);
    VirtualTable.Open;
    VirtualQuery := TVirtualQuery.Create(nil);
    try
      VirtualQuery.SourceDataSets.Add(VirtualTable, '', 'VT');
      VirtualQuery.SQL.Text := 'Select SUM(Field1) As Sum1, SUM(Field2) As Sum2, SUM(Field1+Field2) As TotalSum From VT';
      VirtualQuery.DataTypeMap.AddFieldNameRule('Sum1', ftFloat);
      VirtualQuery.DataTypeMap.AddFieldNameRule('Sum2', ftFloat);
      VirtualQuery.DataTypeMap.AddFieldNameRule('TotalSum', ftFloat);
      VirtualQuery.Open;
      Assert(VirtualQuery.FieldByName('Sum1').DataType = ftFloat);
      Assert(VirtualQuery.FieldByName('Sum2').DataType = ftFloat);
      Assert(VirtualQuery.FieldByName('TotalSum').DataType = ftFloat);
    finally
      VirtualQuery.Free;
    end;
  finally
    VirtualTable.Free;
  end;
end.



Stefano Monterisi
Posts: 21
Joined: Wed 13 Dec 2017 15:11

Re: UNSUPPORTED DATA TYPE MAPPING!

Post by Stefano Monterisi » Mon 03 Sep 2018 14:59

Hi Maxim,
first of all, after disinstall and reinstall your night build VirtualQuery is not present a Design time in IDE.
After, this is the error generated by your console code:
Project Project9.exe raised exception class EUnsupportedDataTypeMapping with message 'Unsupported data type mapping: 'VarChar' to "Float'.


Thanks,
Stefano

MaximG
Devart Team
Posts: 1095
Joined: Mon 06 Jul 2015 11:34

Re: UNSUPPORTED DATA TYPE MAPPING!

Post by MaximG » Tue 04 Sep 2018 09:01

It seems that there are some old DAC units on your computer. To solve the issue with UniDAC, please try the following:


1) close RAD Studio;
2) uninstall all DAC products;
3) Open RAD Studio, select the Component ->Install Packages menu, in the appeared dialog Remove the following items:

"Devart Universal Data Access Components"
"Devart Data Access GUI VCL related Components"
"Devart Universal Data Access GUI VCL related Components"
"Devart Data Access Components"
"Devart Universal Data Access FMX Components"
"Devart Universal Data Access GUI FMX related Components"
"Devart Data Access GUI FireMonkey related Components"
"Devart DataSet Manager"
"Devart Controls"
"Devart Virtual Data Access Components"
and other available DAC products

Press OK

4) In the main menu go to Tools->Options->Environment Options->Delphi Options->Library.
5) In the 'Select Platform' combobox select 32-bit Windows;
6) Open the path editor 'Library path';
7) Delete all the paths related to UniDAC - these paths values inlcude 'C:\Program Files (x86)\Devart\UniDAC for RAD Studio 10.1\Lib\Win32', 'C:\Program Files (x86)\Devart\UniDAC for RAD Studio 10.1\Bin\Win32' and other;
Repeat steps 5-7 for the 'Select Platform' combobox values: iOS Device, Android, OS X, 64-bit Windows, iOS Simulator.

8) remove all *dac*250.bpl, *provider250.bpl, *crcontrols250.bpl, *vquery250.bpl and datasetmanager250.bpl files from your computer (please make sure there are no such files on your computer);
9) find all DAC units, like CRParser.dcu, CLRClasses.dcu, MemData.dcu, MemDS.dcu, DBAccess.dcu, MyClasses.dcu, etc. files on your PC and delete them;


After performing the above steps UniDAC will be completely removed.



Only after this, install the night build of UniDAC (27-August-2018), make sure that there are no errors during the installation and check the operability of the above sample. Let us know the results

To display the component list on the component palette, try resetting display settings of this palette :
"Tool palette" - properties "Show palette categories"\"Reset palette ..."

Stefano Monterisi
Posts: 21
Joined: Wed 13 Dec 2017 15:11

Re: UNSUPPORTED DATA TYPE MAPPING!

Post by Stefano Monterisi » Tue 04 Sep 2018 11:15

Please send me link for download night build, thanks

MaximG
Devart Team
Posts: 1095
Joined: Mon 06 Jul 2015 11:34

Re: UNSUPPORTED DATA TYPE MAPPING!

Post by MaximG » Tue 04 Sep 2018 11:57

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

Stefano Monterisi
Posts: 21
Joined: Wed 13 Dec 2017 15:11

Re: UNSUPPORTED DATA TYPE MAPPING!

Post by Stefano Monterisi » Tue 04 Sep 2018 15:35

Hi,
your link is for 22-07-2018 that is no available;
I have installed 27-08-2018 night build after remove ALL devart components;
It works (your console test);
after I have installed UNI components, and it don't work AT DESIGN TIME assignement and creation of fields and query execute (always "Varchar" to "float" error);

Stefano Monterisi
Posts: 21
Joined: Wed 13 Dec 2017 15:11

Re: UNSUPPORTED DATA TYPE MAPPING!

Post by Stefano Monterisi » Wed 05 Sep 2018 10:25

So, it seems that VirtualDAC standalone works (night build release), but I must use also UNIDAC...

MaximG
Devart Team
Posts: 1095
Joined: Mon 06 Jul 2015 11:34

Re: UNSUPPORTED DATA TYPE MAPPING!

Post by MaximG » Wed 05 Sep 2018 11:12

We are glad that you got the correct results using the test console application. The build from 22-07-2018 has long been deprecated and certainly no longer available for download. Please remove all our products
from 27-08-2018, check again that in your environment, there are no paths to outdated versions of the source codes of our products. After that install unidac73d25pro_05_09_2018 sent to your e-mail and test the operability of your projects using it. Let us know the results

Stefano Monterisi
Posts: 21
Joined: Wed 13 Dec 2017 15:11

Re: UNSUPPORTED DATA TYPE MAPPING!

Post by Stefano Monterisi » Wed 05 Sep 2018 14:23

Hi Maxim,
thank you, but I don't have received emails...
Please resend to monterisi@sesamoweb.it or info@sesamoweb.it
Thanks in advance,
Stefano

MaximG
Devart Team
Posts: 1095
Joined: Mon 06 Jul 2015 11:34

Re: UNSUPPORTED DATA TYPE MAPPING!

Post by MaximG » Thu 06 Sep 2018 12:39

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

Stefano Monterisi
Posts: 21
Joined: Wed 13 Dec 2017 15:11

Re: UNSUPPORTED DATA TYPE MAPPING!

Post by Stefano Monterisi » Thu 06 Sep 2018 16:35

Hi Maxim,
thank you.
At first launch, all works well. I will try to test extensively in next day with a bigger project...
Thanks a lot,
Stefano

MaximG
Devart Team
Posts: 1095
Joined: Mon 06 Jul 2015 11:34

Re: UNSUPPORTED DATA TYPE MAPPING!

Post by MaximG » Tue 11 Sep 2018 11:18

Thank you for good news. We will wait for the testing results from you.

Post Reply