Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't convert num to string in report
Message
De
13/10/2003 09:48:59
 
 
À
12/10/2003 23:32:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00837991
Message ID:
00838068
Vues:
25
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
Fil
Voir

Click here to load this message in the networking platform