1 Reply Latest reply on Dec 3, 2003 2:36 PM by 251531

    SUM Function returns wrong value

    379732
      Hi All,

      I am executing the following SQL statement under Vb6.0 and Oracle Database 9.2.0.1.0:

      "SELECT SUM([fieldname]) Total from [Table]"

      and the return value always have diferences from the correct value. [FieldName] is NUMERIC (20,2) and I don�t have any value of the table with round problems.

      Does anybody know what is happening ?