'Delphi DBText displays #### instead of number
I am using 3 TDBText components on my form and using the following SQL to populate them:
TO_CHAR(myField, '0000.00') "AMOUNT"
where myField are 3 different numeric fields.
One of them is displaying correctly (eg '9983.66'), but the other 2 are displaying as '#######'. I've checked the properties for each DBText and they are identical (apart from the field).
Solution 1:[1]
Sorry, just figured it out. There weren't enough zeros in the mask to accomadate the number. I've changed the format to '000000.00' and it's working fine
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | NiMuSi |