Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Diff. between Numeric with precision, Currency and Doubl
Message
 
To
10/06/2003 10:18:52
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00798235
Message ID:
00798747
Views:
27
>However, IIRC, on a TextBox directly conected to the field, the user would only be able to type 2 decimals.

Yes, that is generally what we want in a business app.

>If it causes you trouble to have more significant decimals than displayed, you should save data with the round() function.

Yes I gave this a thought and even with my mostly previous experience with FPD I used to round() those numeric fields whenever I used a * or / in a calculation, as IMO, this is where decimals are affected only. So I can keep on using this method to keep myself from future troubles as in such a case 5.23456 (5.23) when added to a similar value (assuming these are invoice line items amount derived by qty * rate) with 5.02247 (5.02) the full precision will give me 10.25703 (10.26). In case I would have rounded the line item amounts above I would have got 10.25 which is fair enough.

>In other cases, you might be happy with the ability to have more decimals available.

Yes I think so. especially when specs change for decimals.

Thanks for all the insight Hilmar.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform