Page 1 of 1

Wrong result at select query

Posted: 21.04.2010, 07:42
by h.o.o.k
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.

Posted: 21.04.2010, 13:33
by Wild_Pointer
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.

Posted: 01.05.2010, 20:17
by mdaems
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