Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Currency value is out of range
Message
From
14/02/2005 13:08:30
Joel Leach
Memorial Business Systems, Inc.
Tennessee, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Currency value is out of range
Environment versions
Visual FoxPro:
VFP 7 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00986704
Message ID:
00986704
Views:
240
I get this error when dividing a currency value by zero. A normal numeric value will return asterisks. Example:
? 1/0   && prints asterisks
? $1/0  && "Currency value is out of range" error
Is there a setting that will make the currency values behave like normal numeric values? I am changing several of my fields from numeric to currency types, and bad data could cause some views with calculated fields (i.e. price/qty) to bomb.

Thanks.
Joel Leach
Microsoft Certified Professional
Blog: http://www.joelleach.net
Next
Reply
Map
View

Click here to load this message in the networking platform