How fix Money values with iwdbedit before save

[cprmlao@hotmail.com]

Hi,

I need to fix money values of a IWDBEDIT before save it to a  firebird DB table.
I use a MaskMoney JS plugin to format the money entry data.
Alter I enter data, my front end shows for sample: "$ 10,00". Next, I call an AsyncClick  of a Button as:

Code:

procedure TMyform.BtnSaveAsyncClick(Sender: TObject;  EventParams: TStringList);
begin
    // Here I´d like to fix the currency format before save to DB
    // But, is too late.  An error occur saying my entry field "$ 10,00" is not a format valid
end;

I could fix it in the front end, before call the async click. But, the field  will shows in wrong format in browser.

How could I fix it on back end before save the record?

Regards,
Luiz

[kudzu]

The easiest way is to not databind that field and then manually load/save it to the data field.

[Jose Nilton Pace]

Hi Luiz, in this page https://github.com/plentz/jquery-maskmoney:

Code:

.maskMoney('unmasked')

Return a float value (ex.: 'R$ 1.234,56' => 1234.56). PS: If you have only one input field, you should use this way, since it will always return an array.

Code:

.maskMoney('unmasked')[0]

[cprmlao@hotmail.com]

Hi Luiz, in this page https://github.com/plentz/jquery-maskmoney:

Code:

.maskMoney('unmasked')

Return a float value (ex.: 'R$ 1.234,56' => 1234.56). PS: If you have only one input field, you should use this way, since it will always return an array.

Code:

.maskMoney('unmasked')[0]

Thank you,

I am using it now.