Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Numeric format
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01157946
Message ID:
01157956
Views:
23
>>Hello.
>>
>>I have a field like this Cantidad n(16,6)
>>
>>sometimes the user writes 1345.9 4505.103 5413.44
>>
>>but when I print the field in the report writer the output is
>>
>>1,345.900000
>>4,505.103000
>>5,413.440000
>>
>>I don't want to show the last zeroes in the decimal part.
>>
>>I've been trying to do that with Transform but I can't find a way.
>>
>>c.x.
>
>you may try alltrim(padr(myNumber,16))

Nope,
This doesn't remove the trailing zeros.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform