problems using oracle fieldtype float

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Aufhauser
Posts: 56
Joined: Mon 21 Nov 2005 09:44
Location: Herzogenburg, Austria

problems using oracle fieldtype float

Post by Aufhauser » Mon 11 Apr 2016 15:03

I have problems using ODAC 9.6.22 with oracle fieldtype 'float'.
Setting
OraSession.Options.EnableNumbers:= False;
Query.Fields[nn].AsFloat truncates the values.
If I set EnableNumbers:= True the values are not truncated.
V 9.6.20 of ODAC works correct!

Stefan

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: problems using oracle fieldtype float

Post by AlexP » Tue 12 Apr 2016 08:38

Hello,

Please specify the field type in the Oracle database and the value that is trimmed on disabling the EnableNumbers option.

Aufhauser
Posts: 56
Joined: Mon 21 Nov 2005 09:44
Location: Herzogenburg, Austria

Re: problems using oracle fieldtype float

Post by Aufhauser » Wed 13 Apr 2016 11:23

The datatype used in create-statement was the pseudotype 'float'!

Stefan

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: problems using oracle fieldtype float

Post by AlexP » Mon 18 Apr 2016 11:53

We can't reproduce the issue. Please specify the number that is cut.

Aufhauser
Posts: 56
Joined: Mon 21 Nov 2005 09:44
Location: Herzogenburg, Austria

Re: problems using oracle fieldtype float

Post by Aufhauser » Fri 22 Apr 2016 08:52

The error only occurs if my programm runs as Com-DLL in memory of another program (Intergraph GeoMedia) so it is very diffcult to build a test-program to show the problem.
If I install V 9.6.22 my program does not work, if I use the old version 9.6.20 my program works (without canges in my code).
My question: did you change something in your program? (Verision 7.2.9 of SDAC had a similar problem)

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: problems using oracle fieldtype float

Post by AlexP » Tue 26 Apr 2016 13:00

Since a lot of modifications were made between these two versions, and we couldn't reproduce the problem, we can't tell what affected this behavior. Therefore try to create a sample reproducing the problem, in order for us to be able to reproduce and fix it.

Post Reply