Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Width of Calculated fields in select-SQL
Message
 
À
24/09/1998 23:26:32
Sudhir Arora
Userease Software Pvt. Ltd.
New Delhi, Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00140679
Message ID:
00140706
Vues:
28
>How can width of calculated fields in Select-SQL command be formatted ? If we take sum of 2-3 numeric fields of N 11,2 width using select-SQL , the resultant width sometimes is more than N 14,2 and if I am showing the result of the cursor from select-SQL directly in a list box - I have to keep the width of the column in list box accordingly.

Sudhir,
Use: SELECT field1*field2 + 00000000.00 as CALCFIELD .......

Just add the length you want to each calculated field.

HTH
Barbara
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform