UNSUPPORTED DATA TYPE MAPPING!

[Stefano Monterisi]

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]

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

[MaximG]

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]

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]

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]

Please send me link for download night build, thanks

[MaximG]

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

[Stefano Monterisi]

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]

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

[MaximG]

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]

Hi Maxim,
thank you, but I don't have received emails...
Please resend to [email protected] or [email protected]
Thanks in advance,
Stefano

[MaximG]

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

[Stefano Monterisi]

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]

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

[MaximG]

Please, clarify exactly what issue in VirtualDAC you are interested in.