Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Convert out of range field value to string
Message
De
26/03/2020 08:16:52
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
26/03/2020 02:59:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01673822
Message ID:
01673828
Vues:
40
>Hi!
>
>
CREATE TABLE t ( t numeric(8,5))
>INSERT INTO t VALUES ( 1000 )
>?TRANSFORM(t)
>
>
>outputs
>
>**.*****
>
>How to get real field value as string ?

alltrim(str(t))

You can also copy the value into a variable or a property of a scatter object and use transform() on that. It seems that the 2nd parameter of transform() defaults to "99.99999" for a n(8,5) field. No field, no strict default.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform