nope, DB`s math is designed for speed more than precision, plus this is more a problem with representing numbers accuratley on a system that uses base two and converts it to decimal with only 16 or 32 bits normaly allocated to hold the number, hence you get these limitations, you could write a parser to accept the numbers as strings and then do the math "longhand", recreating the basic math operations eg
string one is
123456789123456789
string two is
1234
then add them one digit at a time
9+4=13
thats 3 carry one...add that to the string answer$...so
8+3+1 (the one you carried) = 12
thats 2 carry one..answer$ is now 23
etc...
looks painfully long winded, but thats what computers are for, doing painfully long winded calculations on our behalf
, you just need to write a loop that will repeat until all the digits have been calculated, addition and subtraction are not too bad, but multiplication and division may need some research to impliment, cheers.
Mentor.
System spec : Pentium 3.0Ghz, 512MB DDR, 2x160Gb HD (using icewave hd coolers ), DVD RW/CD RW (all modes), multimedia front panel, 6 way surround sound, ATI radeon 9800Pro 128mb.
