🚀 go-pugleaf

I posted this question a few months ago (with sample code) and never got a
reply.  Being busy on other projects I've neglected to visit this forum as
much as I should so I don't know whether someone else has posted the same
question and received an answer.  Any way...

I have a database in Oracle 8i that stores values to 9 decimal places.
Storage is fine.  Looking at the data in SQL*Plus shows the correct numbers
as I entered them.  However returning the values out of the database using
either ADO or third party Direct Oracle Access the values are rounded which
is very annoying when precision is paramount.  I wonder if anyone else has
had this problem and can suggest a solution.  I was thinking it was Oracle,
but I can't find a way of increasing the precision of the returned values
but then again I can't find a way of increasing the returned precision in
Builder.  Currently I am having to multiply the values by 100,000 and divide
them again when they come out.  However that makes numerical comparisons
awkward while the data is still in the database.

One suggestion was to look up whether BCD are used on the values...it's been
a while so I can quite remember what the person said but I remember being
thoroughly confused by his statement.

--

Yours faithfully, Graham Reeds.
grahamr@omnieng.co.uk | http://omnieng.co.uk/