General information
Category:
Coding, syntax & commands
Normally asterisks are printed (and stored in a numeric field) when there is a numeric overflow such as a number is too large for the field containing the numeric value or it is the result of a calculation with divide by zero (if not handled). Check the table that contains the number to see if it actually contains the number that you expect or if it contains ****. If the latter, increase the width of the numeric field that contains the value or set a break point at the place where the value is set to ensure that you are not getting a numeric overflow.
If you are getting this only on some records and not others and your report is from a query, and cvl is being set by some conversion function like val(), your query may be truncating the numeric field width based on the first value that it finds. Check the structure of the query against the source table. If the numeric field width is less than you expected, that would cause a numeric overflow for records that are larger than the one that the queried field is based on.
HTH
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only