Hello,
I have this problem. i use oracle 10g db and there i have table with field of NUMBER datatype. There i have value (number) with decimal point etc. (0.45).
i using zeos 6.6.6 .
so and when i open select query that result is 4 (original in db is 4.58).
when i open this query in sql developer that all is ok.
where is a problem please??
i am sorry for my English.
Wrong result at select query
Moderators: gto, EgonHugeist
-
Wild_Pointer
- Expert Boarder
- Posts: 164
- Joined: 18.03.2008, 13:03
- Contact:
h.o.o.k,
what programming tool do you use? There have been problems with lazarus users because of the way lazarus does string to float conversions if I remember right. The indication of this would be different result when decimal separator is point and comma.
Also please provide the table structure you are using and query you execute to get the result.
what programming tool do you use? There have been problems with lazarus users because of the way lazarus does string to float conversions if I remember right. The indication of this would be different result when decimal separator is point and comma.
Also please provide the table structure you are using and query you execute to get the result.
-
mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
h.o.o.k,
If you're a Lazarus issue as Wild_Pointer proposes, you can find the solution in this patch :
http://fisheye2.atlassian.com/changelog/zeos/?cs=761
This patch is done already in 6.6-patches branch and will be available in 6.7 when it comes available.
If you're not a Lazarus user you'll have to provide more information.
Mark
If you're a Lazarus issue as Wild_Pointer proposes, you can find the solution in this patch :
http://fisheye2.atlassian.com/changelog/zeos/?cs=761
This patch is done already in 6.6-patches branch and will be available in 6.7 when it comes available.
If you're not a Lazarus user you'll have to provide more information.
Mark
