>See
http://support.microsoft.com/kb/78113, this used to be Q78113 that applied to VFP as well. This known limitation affects any system like VFP that follows IEEE 754, so at least you aren't alone!
>
>Is the data in Oracle? We used to get monster numeric values out of Oracle using strings. If you've already got RVs, first try changing the field type to a c(35) to see what happens- you may be astonished to find it actually works. If that doesn't fly, make the RV against an Oracle View that takes care of the translation to/from a string.
This is mssql 2008
Thanks for the kb refs.
Have convinced them they can live without the high dec precision on very big number right now as it is very much edge cases but I know this will resurface. Dow Jones has a pretty diverse client base <s>
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.