Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Width of Calculated fields in select-SQL
Message
 
To
24/09/1998 23:26:32
Sudhir Arora
Userease Software Pvt. Ltd.
New Delhi, India
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00140679
Message ID:
00140706
Views:
27
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform