Radicore Forum: Framework » Problem with Numeric Field

Home » RADICORE development » Framework » Problem with Numeric Field

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with Numeric Field [message #3003]

Tue, 19 June 2012 12:29

juanguilarte
Messages: 27
Registered: June 2012

Junior Member

When I update a record (upd1) and the numeric fields has decimal point and are not edit, this numeric field are shift like it lost de decimal point (,).
My radicore version is 1.75

Example: 175,00 is convert to 17.500,00

if they are something wrong please let me know

Thank you in advance

Report message to a moderator

Re: Problem with Numeric Field [message #3004 is a reply to message #3003]

Wed, 20 June 2012 02:20

AJM
Messages: 2363
Registered: April 2006
Location: Surrey, UK

Senior Member

What is your country/locale setting? All decimal points are '.' (period) internally, but are only displayed or input as ',' (comma) if your locale specifies it.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Problem with Numeric Field [message #3005 is a reply to message #3004]

Wed, 20 June 2012 03:01

juanguilarte
Messages: 27
Registered: June 2012

Junior Member

My country es Venezuelas and the locale setting is like you mentioned all decimal point are '.'. and it work ok when they display the amounts with comma (decimal point) . But when the record are going to be updated and the field is not edit, the unformat function eliminated the commas and that produce a mistake with the numeric fields.

Report message to a moderator

Re: Problem with Numeric Field [message #3006 is a reply to message #3005]

Wed, 20 June 2012 04:58

AJM
Messages: 2363
Registered: April 2006
Location: Surrey, UK

Senior Member

I have tested this on my local PC and I cannot duplicate the problem. Input of '175000' or '175,000' is reformatted to '175000.00' for internal use, and changed to '175,000.00' when displayed on the screen.

The only way that this would be displayed as '175.000,00' is if you locale setting says that:
- decimal point is ',' (comma)
- thousands separator is '.' (period)

The formatNumber() and number_unformat() functions use the same locale settings, so I cannot see how they can get out of step.

Can you step through with your debugger and see what happens inside both of these functions?

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

[Updated on: Thu, 31 July 2014 03:55]

Report message to a moderator

Re: Problem with Numeric Field [message #3007 is a reply to message #3006]

Wed, 20 June 2012 10:40

juanguilarte
Messages: 27
Registered: June 2012

Junior Member

The problem occurs with the numeric fields with decimal point that are in the data base and are not going to be change (not edit), other fields are going to be change using pattern "upd1". I supposed that it occurs when it merge the $_POST array with the originaldata ($fieldarray) and when the unformat function is calle it eliminate the decimal point '.' and the numeric fields that were with the "not edit" in the screen are shiffted (for example: 175,00 are convert to 17500,00).

Report message to a moderator

Re: Problem with Numeric Field [message #3008 is a reply to message #3007]

Wed, 20 June 2012 15:17

AJM
Messages: 2363
Registered: April 2006
Location: Surrey, UK

Senior Member

Your locale (language = Spanish) was displaying the value "175,000.00" as "175.000,00", but because the field was set to 'noedit' the value was not being returned in the $_POST array. This meant that it was still set to "175,000.00" when it went through the number_unformat() function in the wrong format.

I've made a few tweaks to two scripts (see attached file). Can you let me know if it fixes your problem.

Attachment: radicore-2012-06-20-fix.zip
(Size: 46.15KB, Downloaded 1062 times)

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

[Updated on: Thu, 31 July 2014 03:54]

Report message to a moderator

Re: Problem with Numeric Field [message #3009 is a reply to message #3008]

Wed, 20 June 2012 18:58

juanguilarte
Messages: 27
Registered: June 2012

Junior Member

I am testing all the system. At the moment everything is working ok. If i have some detail I will let you know.

Thank you very much

My regards

Juan Guilarte

Report message to a moderator

Previous Topic:	post insert function
Next Topic:	Accessing to Radicore from mobile phones

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Oct 31 21:22:12 EDT 2024

Total time taken to generate the page: 0.01230 seconds