Type mismatch for databasetype Real
Posted: Wed 14 Dec 2016 09:07
Monday I downloaded dbExpress Driver for SQL Server (trial) and installed it into DelphiXE7.
We are in the process of upgrading some projects from Delphi2010 to XE7.
It seems that dbexpress was the last missing piece - and the projects now does compile.
However I am getting type mismatch for databasefields of type "real" when running the project.
The persistent fields in the projects are TFloatFields, but it seems that the current driver wants the fields to be TSingleFields)
(cldsHuse: Type mismatch for field 'H_HUHPRIS', expecting: Float actual: Single )
I don' quite understand this, because readme.html states:
real ftFloat TFloatField
Is this an error in trial-version ? Will it be the same when buying the product. ?
Can I do something to fix it. On your website you're saying:
dbExpress drivers have additional options to control data type mapping, which allow to customize correspondence between database and Delphi data types.
But how do I do that ?
René / SSV
We are in the process of upgrading some projects from Delphi2010 to XE7.
It seems that dbexpress was the last missing piece - and the projects now does compile.
However I am getting type mismatch for databasefields of type "real" when running the project.
The persistent fields in the projects are TFloatFields, but it seems that the current driver wants the fields to be TSingleFields)
(cldsHuse: Type mismatch for field 'H_HUHPRIS', expecting: Float actual: Single )
I don' quite understand this, because readme.html states:
real ftFloat TFloatField
Is this an error in trial-version ? Will it be the same when buying the product. ?
Can I do something to fix it. On your website you're saying:
dbExpress drivers have additional options to control data type mapping, which allow to customize correspondence between database and Delphi data types.
But how do I do that ?
René / SSV