🚀 go-pugleaf

I've got an Oracle database which I am querying for values.  These values
are 9 decimal places in length, and are stored in Oracle as such.  If I
perform the same query from within SQL*Plus I get the correct results
displayed.  However when I retrieve these values from the database they are
rounded to four decimal places.  I have tried using various methods to get
back the correct values including FormatFloat(,); which just appends more
zeros to the value.

Does anyone have any ideas?

Code below:
...
fprintf(fp, "%s,", FormatFloat("#0.000000000",
ADOQuery->FieldByName("LONGITUDE")->AsFloat));
fprintf(fp, "%s,", FormatFloat("#0.000000000",
ADOQuery->FieldByName("LATITUDE")->AsFloat));
fprintf(fp, "%s\n", FormatFloat("#0.000000000",
ADOQuery->FieldByName("HEIGHT")->AsFloat));
ADOQuery->Next();
...

Returned values:
-2.467600000,53.700100000,217.714000000
Should return:
-2.467589257,53.70012166,217.714
Oracle displays:
-2.4675893 53.7001217    217.714

--

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