Thanks for all the comments on this. Didn't realise there were so many things to worry about when dealing with currency!
The system I'm developing is only dealing with US dollars right now but I would hope it might make it's way into other countries at some point. Even with dollars, I will have to deal with more than two decimal places though. The application is aimed at independant music bands to manage their businesses and one of the things it does is import data from places like iTunes, Rhapsody, etc whose royalty payments commonly extend to three decimal places or more. That often give rise to some rounding issues. I do all the math using however many decimal places are given to me and then round the total to two decimal places, then calculate how much is owed to each band member based on that total. But whoever writes the checks for some of the above outfits doesn't seem to use the same logic since the checks I get are often different than what I calculate by a few pennies (usually more than the total I calculate). Not really a big deal but it does require some otherwise-unnecessay accounting entries to deal with the rounding errors. Pete Haworth _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
