Editing db-fields with decimals
lazarus / 16-Databases

----------------------------------------------------------------------
JanH · 2006-04-06 10:59

Hi there,

I want to use a currency field in my firebird 1.5 database. Its type
is decimal(15,2).
The content of the field is shown correct but editing is not possible
(language of system is german!). Every change I take is lost after a
post and the old value is shown.
I think it's a conflict between german decimal format (123,45) and the
english one ( 123.45).

Has someone an idea how i can solve it - excepting the possibility of
create an update statement after posting the dataset? Because I want
also to insert a new dataset with any decimal values, and how should i
update a record without a primary key?

Hope you understand my english ... and problem ;-)

...regards...

----------------------------------------------------------------------
JanH · 2006-04-10 10:27

no one seems to have a solution...

now I have changed the field type into integer and multiply the
entered value with 100

----------------------------------------------------------------------
barko · 2006-04-10 18:42

I do this in my programs (slovenian language, same decimal format as
yours):
Code: [Select]
--cut--
initialization
   DecimalSeparator:=',';
   ThousandSeparator:='.';
--cut--


In objectinspector (for dbgrid) columns I set
Code: [Select]
DisplayFormat:='###,##0.00';