The best (safest?) way I have found to handle non scientific math is to work strictly with integers and multiply and divide using ROUND/TRUNC as required to gain the precision required. This includes way more than SQLite situations as well. Borland (Code Gear) seem to be the only developer tools producer to recognize the need for "business" math with their native BCD data type.
Fred > Seems like I should handle the formatting in my application. Not sure > I agree that sqlite is not the place to do output formatting - it > provides lots of date and time formatting features so at least in that > area, output formatting is available. > > Thanks also for the info re accuracy/REAL formatting. I will change > my db design accordingly. > > Thanks, > > Pete Haworth > > > > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
