Information générale
Catégorie:
Codage, syntaxe et commandes
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement