Changing Decimal point to Decimal comma
Changing Decimal point to Decimal comma
I've defined DECIMAL type fields. The value that is to be entered should be with a Comma (,) instead of the standard point (.)
So: I want :123,45 but has to be inputed as: 123.45.
Is this to be changed ?
The App settings are: Ron
So: I want :123,45 but has to be inputed as: 123.45.
Is this to be changed ?
The App settings are: Ron
Re: Changing Decimal point to Decimal comma
Hi,
Ithought that I found the solution
At every field definition you can set de Data Format, I set that to a comma setting (The last option)
Then I put a value in the field, the value of course with a comma, no problem
However, after saving the result was... comma became period AND the given value was truncated
So, what goes wrong?
Ithought that I found the solution
At every field definition you can set de Data Format, I set that to a comma setting (The last option)
Then I put a value in the field, the value of course with a comma, no problem
However, after saving the result was... comma became period AND the given value was truncated

Re: Changing Decimal point to Decimal comma
Hi,
Anyone a solution for a Decimal comma?
Ron
Anyone a solution for a Decimal comma?
Ron
Re: Changing Decimal point to Decimal comma
Hi,
you can change the data formats in "dataFormats.cfg" in AppGini\add-ons folder.
you can change the data formats in "dataFormats.cfg" in AppGini\add-ons folder.
Re: Changing Decimal point to Decimal comma
i SkayyHH ,
Thank you for the reply, however
The field is not a currency field, so I've selected Points for Thousands and Comma for 2 decimals
The value given in the field has to be (I want) with a decimal point instead the wanted decimal comma
Thank you for the reply, however
The field is not a currency field, so I've selected Points for Thousands and Comma for 2 decimals
The value given in the field has to be (I want) with a decimal point instead the wanted decimal comma
Re: Changing Decimal point to Decimal comma
Oh, i understand.
Sorry, i can´t help with this. This need to be coded from a professional
Sorry, i can´t help with this. This need to be coded from a professional

Re: Changing Decimal point to Decimal comma
Have you ask chatGPT? It can help with code and know how to place the it.
Re: Changing Decimal point to Decimal comma
Hi Skayyhh,
Thank you for your reply, however I’m not going to program my self.
If this functionality doesn’t work well then it is up to AppGini to modify
Ron
Thank you for your reply, however I’m not going to program my self.
If this functionality doesn’t work well then it is up to AppGini to modify
Ron
- Marcelo Vitoria
- Veteran Member
- Posts: 87
- Joined: 2016-10-11 12:08
Re: Changing Decimal point to Decimal comma
Hello Ronp
Add this line to the dataformats.cfg file:
DESCRIPTION IN MENU ( Sample 21.345,67); CONCAT(' ', FORMAT(%%FIELD%%, 2, 'de_DE'))
It solves the problem when displaying the field, but it does not display when the field is being edited.
There may be problems with fields where "Show column sum" is checked, AG sometimes cannot display the field correctly, but I believe it is a bug in AG because it does not occur in all tables.
I hope this helps and good luck.
Add this line to the dataformats.cfg file:
DESCRIPTION IN MENU ( Sample 21.345,67); CONCAT(' ', FORMAT(%%FIELD%%, 2, 'de_DE'))
It solves the problem when displaying the field, but it does not display when the field is being edited.
There may be problems with fields where "Show column sum" is checked, AG sometimes cannot display the field correctly, but I believe it is a bug in AG because it does not occur in all tables.
I hope this helps and good luck.
Marcelo Vitoria
Coding since 1982 !
Basic Sinclar - Clipper - Visual Foxpro - VB6 - PHP
AppGini 24.18 - AdminLTE - SPM
https://www.workspaceservices.com.br/eng
Coding since 1982 !

Basic Sinclar - Clipper - Visual Foxpro - VB6 - PHP
AppGini 24.18 - AdminLTE - SPM
https://www.workspaceservices.com.br/eng
Re: Changing Decimal point to Decimal comma
Hi Marcelo,
Great, it works. Unfraternally not on the Total field, but I can live with that
Thank you
Ron
Great, it works. Unfraternally not on the Total field, but I can live with that
Thank you
Ron