Home » Developer & Programmer » Forms » how to display decimal numbers in text items (Forms 12c)
| how to display decimal numbers in text items [message #679847] |
Tue, 07 April 2020 05:58  |
 |
calacausi
Messages: 23
Registered: March 2012
|
Junior Member |
|
|
I should display a decimal numeric value into a pure text item (data type: char, no format mask).
everything seems to work if item is not bound to database; but, if text item is bound to a numeric DB field, leading zero is trimmed!
ie: if DB value is 0,123456789, it is rendered as ",123456789".
this is awful! how can I fix this bug? Setting data type as Number, or using format mask would force me to a given format (ie: truncate decimal digits to a given quantity).
Again, note that if my text item is not bound to DB, number is displayed correctly.
|
|
|
|
|
|
|
|
|
|
| Re: how to display decimal numbers in text items [message #679852 is a reply to message #679850] |
Tue, 07 April 2020 09:21  |
|
calacausi
Messages: 23
Registered: March 2012
|
Junior Member |
|
|
cookiemonster wrote on Tue, 07 April 2020 14:40So why don't you make it a number and set it to accept ten decimals places?
Im trying several ways, unsuccessfully.
In my item property palette, I put Data Type = Char, Number, Long, RNumber... getting the same output.
If text item isnt bound to DB field, value is display correctly (0,0012...).
If text item is bound to DB field, leading zero is trimmed (,0012...).
How can I set text item to accept decimal places?
|
|
|
|
Goto Forum:
Current Time: Fri May 02 02:50:28 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
