Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transform Oddities
Message
From
04/07/2001 10:15:41
 
 
To
04/07/2001 09:50:19
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00526657
Message ID:
00526671
Views:
24
That's the problem I don't know how many decimals it will be

It's actually in a select statement built on the fly
Select Max(_screen.Textwidth(Transform(Mytable.field1))) as column1, ;
Max(_screen.Textwidth(Transform(Mytable.field2))) as column2 ;
from tableX into ...etc
The idea is that this will give the maximum width in pixels required for a grid column, the reson for using transform is that the format (and even data type) of the underlying table does not matter

But thanks for the input :)

>If trailing zeros don't matter, use:
>
>alltrim(str(-8.81,20,2)) && for two decimals
>
Will Jones
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform