I was told once by someone that writes math libraries that you shouldn't
start loosing precision
until the 8th decimal place, so you should be OK.

Luis Madaleno wrote:

> Daniel Rail wrote:
>
>> One way would be to create a UDF to make those calculations. The
>> other would be to cast your values as DOUBLE PRECISION values before
>> the multiplication, but you might loose some accuracy in the decimals,
>>
>>
>>
>
> Can you please tell me what would be the accuracy in the decimals I can
> loose? (using
>
> DOUBLE PRECISION)
> Will it at least be accurate at 6 decimal places?
> Since this is for currency values if I get an accuracy of 6 decimal places at least, its fine for me.
>
> Luis
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
Thomas Miller
Chrome Portal Project Manager
Wash DC Delphi SIG Chairperson
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://www.cpcug.org/user/delphi/index.html
http://sourceforge.net/projects/chromeportal/
http://sourceforge.net/projects/uopl/
http://sourceforge.net/projects/dbexpressplus