Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Currency Data Type / Is this good??
Message
From
30/08/2003 10:31:47
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00824740
Message ID:
00824768
Views:
29
>Unless you need to hold currency in lower than 1/1000 you should be fine.
>
>The decimal places translate directly into SQL Server. I think the width is larger in SQL, but am not sure.
>
>In short, you should be ok.

That should be "lower than 1/10,000" (4 decimals).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform