real datatype

[yartoo]

Hi,

My software environment...
RAD Studio XE6
Ms SQL Server 2012
Windows 8.1

We have put the Db Express driver (dbexpsda40.dll) dated 29 May 2014 in with our Delphi XE6 built software and it does not handle columns of the real datatype. The usual behaviour is to get an access violation. It varies.
We have used an older driver dated from 2011 and it still works.
Changing the data type of the columns in the database from real to float worked around the problem.
We are OK with the work-around.
This is more an FYI for you.
Cheers
Shaun

[azyk]

Thank you for the information. We have reproduced this problem and fixed it. This fix will be included in the next dbExpress driver for SQL Server build.

[PaulC]

I'm not sure the "real" field is working correctly in 6.5.7.0 under XE3 Enterprise, SQL Server 2012. We have a column with a real type and it returns all 0's when it should return the values in the table. Can someone confirm this is working for a similar setup? It worked in our Delphi 2009 version.

It's easy to reproduce, create a table with a "REAL" field, add a bunch of data, add a TSQLConnection, TSQLQuery and "select *" from the table. We see 0's for all the REAL field values (XE3 Enterprise, SQL Server 2012, dbexpsda40.dll 6.5.7.0)

[PaulC]

I've also changed our logic to use the FLOAT field type and it works as expected. I'm a little concerned there's a "bug" in the driver that may cause some hidden problem around floating point type fields.

[azyk]

Thank you for the information. We have reproduced this problem. If you want to get a working dbexpsda40.dll library, send your e-mail and license number to andreyz*devart*com - and we will send it to you.

[PaulC]

Hi Azyk,

Thanks for the confirmation of the problem. I do want a working version of dbexpsda40.dll, but I can wait for the official release unless you feel the bug in 6.5.7 would jeopardize the stability of our application. I've switched to FLOAT and it works, we don't need REAL support right now, but I don't want an unstable dbexpsda40.dll either.

All the best,
Paul