Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
How to determine precision of certain numeric values
Versions des environnements
Hi,
I am trying to create a cursor filled with the values in the detail band of an FRX file. The values may come form one or more tables or be calculated values. Since this will be done at runtime the environment is exactly the one the report finds and those values will be found with EVAL(Frx.Expr) without regard to where they come from.
When preparing the CREATE CURSOR command I don't know how to determine the precision of numeric values if the Picture field is empty. I'd like the precision to be identical to what shows in the report. I tried using TRANSFORM() and then measuring the length after the decimal point but TRANSFORM(1.50) results in "1.5", not "1.50"
Any suggestions?
TIA,
Alex
Suivant
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