Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Diff. between Numeric with precision, Currency and Doubl
Message
 
À
10/06/2003 10:18:52
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00798235
Message ID:
00798747
Vues:
26
>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
___________________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform