Firebird and float decimal
lazarus / 16-Databases

----------------------------------------------------------------------
xinyiman · 2010-10-11 09:51

I have a question to ask. I lazarus in a database and into a field I
should put a float value with up to two decimal places, how do I
declare the field to do it? Hypothesized that a table named ipootetica
MiaTabella I have to add the field to float to two decimal places, how
can I? Thanks

----------------------------------------------------------------------
stonefull · 2010-10-11 12:15

In Firebird I declare numeric(7,2).

----------------------------------------------------------------------
xinyiman · 2010-10-11 12:16

Thank you. But 7 is integer part and 2 is a decimal part of number?

----------------------------------------------------------------------
stonefull · 2010-10-11 12:40

Yes. Read this:
http://www.alberton.info/downloads/firebird-2-cheat-sheet.gif