Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bug in PADL command?
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01126320
Message ID:
01126340
Views:
25
This message has been marked as the solution to the initial question of the thread.
PADL(MTON(yAmount),9,'0')
>yAmount is a currency field.
>
>PADL(yAmount,9,'0') returns an empty string.
>PADL(CAST(yAmount as Numeric (9,2)),9,'0') returns the result correctly.
>
>Looks like a bug to me.
>
>Thanks in advance.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform