Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How fix Money values with iwdbedit before save
#1
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
Reply
#2
The easiest way is to not databind that field and then manually load/save it to the data field.
Reply
#3
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]
Reply
#4
(06-03-2019, 03:06 PM)Jose Nilton Pace Wrote: 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.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)