Issue Details (XML | Word | Printable)

Key: ODBC-131
Type: Bug Bug
Status: Closed Closed
Resolution: Cannot Reproduce
Priority: Major Major
Assignee: Alexander Potapchenko
Reporter: Everton Lucas
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
ODBC Driver

Numeric field as integer

Created: 12/Aug/11 08:29 PM   Updated: 31/May/12 03:29 PM
Component/s: None
Affects Version/s: 2.0
Fix Version/s: 2.0.1

Environment: Windows 7

 Description  « Hide
I'm working in a project which I need to transfer some data from a firebird database to an oracle database. I'm using ODBC and Oracle Heterogeneous Services to connect in firebird from pl/sql procedures and functions.
When I'm reading numeric fields, the data inside these fields is returned as integer. (e.g. 812,43 returns as 812). The only way I can read the data correctly is dividing it by 100 and multiplying by 100 again. But when I need to use these one in a function(e.g. SUM), it returns as integer again, even when I perform the divide/multiply.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Potapchenko made changes - 05/Jan/12 08:47 AM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 2.0.1 [ 10430 ]
Resolution Cannot Reproduce [ 5 ]
Alexander Potapchenko made changes - 31/May/12 03:29 PM
Status Resolved [ 5 ] Closed [ 6 ]