Recent

Author Topic: Firebird and float decimal  (Read 7918 times)

xinyiman

  • Hero Member
  • *****
  • Posts: 2092
    • Lazarus and Free Pascal italian community
Firebird and float decimal
« on: October 11, 2010, 11:51:37 am »
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
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

stonefull

  • Jr. Member
  • **
  • Posts: 51
Re: Firebird and float decimal
« Reply #1 on: October 11, 2010, 02:15:07 pm »
In Firebird I declare numeric(7,2).

xinyiman

  • Hero Member
  • *****
  • Posts: 2092
    • Lazarus and Free Pascal italian community
Re: Firebird and float decimal
« Reply #2 on: October 11, 2010, 02:16:49 pm »
Thank you. But 7 is integer part and 2 is a decimal part of number?
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

stonefull

  • Jr. Member
  • **
  • Posts: 51
Re: Firebird and float decimal
« Reply #3 on: October 11, 2010, 02:40:13 pm »
« Last Edit: October 11, 2010, 02:42:57 pm by stonefull »

 

TinyPortal © 2005-2018