September 20th, 2013, 02:14 PM
Firebird numeric value 0.00
a have a problem!
i use firebird 2.5 and when i insert or update a record have following issue
im my table i have 3 colums
1 ID integer
2 Name (varchar 50)
3 Value (numeric 4,2)
if the value is 0.00 then when i insert or update is stored 0 !!
if the value is 4.00 then stored just 4 !!
i want to have the full value 4.00!!!
what should i do???
September 21st, 2013, 08:24 AM
All Float or Double number (value) is saved as BIGINT, INTEGER or SMALLINT (look in site FIrebirdSQL for FAQ about it).
0 - 4 digits = smallint
5 - 9 digits = integer
10 - 18 digits = bigint
in decimal representation ( n POWER x )
But, you can to use the "MASK" for show the value as desired!
Example in Delphi:
Maskedit -> mask = ###,###,##0.0000
Show: 999,999,999.9999 value
Last edited by emailx45; September 21st, 2013 at 08:27 AM.
September 25th, 2013, 03:05 PM
Originally Posted by emailx45
you have right!!
Another option is to cast it into the Numeric(14, 2) format in the select statement.