UNSUPPORTED DATA TYPE MAPPING!
-
- Posts: 23
- Joined: Wed 13 Dec 2017 15:11
Re: UNSUPPORTED DATA TYPE MAPPING!
Now I have removed VirtualDac and reinstalled the nightbuild release (trying with a new and fresh installation), but TVirtualQuery is disappeared (Delphi Tokyo)....
-
- Posts: 23
- Joined: Wed 13 Dec 2017 15:11
Re: UNSUPPORTED DATA TYPE MAPPING!
Hi,
Any news or hint? Workaround? A new night build?
I have to remove (all) devart components and reinstall older release?
Thanks,
Stefano
Any news or hint? Workaround? A new night build?
I have to remove (all) devart components and reinstall older release?
Thanks,
Stefano
Re: UNSUPPORTED DATA TYPE MAPPING!
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.
-
- Posts: 23
- Joined: Wed 13 Dec 2017 15:11
Re: UNSUPPORTED DATA TYPE MAPPING!
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
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
Re: UNSUPPORTED DATA TYPE MAPPING!
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 ..."
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 ..."
-
- Posts: 23
- Joined: Wed 13 Dec 2017 15:11
Re: UNSUPPORTED DATA TYPE MAPPING!
Please send me link for download night build, thanks
Re: UNSUPPORTED DATA TYPE MAPPING!
The links for downloading the night builds, which include the required changes were sent to your email
-
- Posts: 23
- Joined: Wed 13 Dec 2017 15:11
Re: UNSUPPORTED DATA TYPE MAPPING!
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);
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);
-
- Posts: 23
- Joined: Wed 13 Dec 2017 15:11
Re: UNSUPPORTED DATA TYPE MAPPING!
So, it seems that VirtualDAC standalone works (night build release), but I must use also UNIDAC...
Re: UNSUPPORTED DATA TYPE MAPPING!
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
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
-
- Posts: 23
- Joined: Wed 13 Dec 2017 15:11
Re: UNSUPPORTED DATA TYPE MAPPING!
Hi Maxim,
thank you, but I don't have received emails...
Please resend to [email protected] or [email protected]
Thanks in advance,
Stefano
thank you, but I don't have received emails...
Please resend to [email protected] or [email protected]
Thanks in advance,
Stefano
Re: UNSUPPORTED DATA TYPE MAPPING!
The links for downloading the night builds, which include the required changes were sent to your email
-
- Posts: 23
- Joined: Wed 13 Dec 2017 15:11
Re: UNSUPPORTED DATA TYPE MAPPING!
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
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
Re: UNSUPPORTED DATA TYPE MAPPING!
Thank you for good news. We will wait for the testing results from you.
Re: UNSUPPORTED DATA TYPE MAPPING!
Please, clarify exactly what issue in VirtualDAC you are interested in.