Question & Answer > View Question

Failure to attempt to save a curency(money) value field

Confluence User - 05 Sep, 2022

failure to attempt to save a curency(money) value field

Hi guys,

i´m have a failure to attempt to save a curency(money) value field in this cenario:

1) Test cenario: Insert an value = U$ 1.000,00 in the transaction record to update store credit an another form.

1) The field value of my form is configured with:

a) Formatting Style: US Style

b) Number of Decimal : 2

c) Validator Type: Numeric

d) Mandatory : Checked

2) This form has a Post Processing update tool with a sql update command to store this field value to another table form.

SQL Command: "update app_fd_conta_contabil set c_saldo_conta = c_saldo_conta - FORMAT(#form.app_fd_transacao.id_valor_transacao#, 2)

where ID = '#form.app_fd_transacao.cboCtContabil#'"

3) Result: This update run without execution erros, but your result is the app to subtrac 1,00 otherwise 1.000,00

Any idea ?

Thanks,

Paulo Nascimento

forms;database

2

Confluence User •

07 Sep, 2022 •

confluenceUser •

1 •

confluenceUser •

Hi, if you intend to perform calculations, I would suggest to store the value directly as a number instead of a formatted string. Then only use formatting when displaying the output value.

Confluence User •

07 Sep, 2022 •

confluenceUser •

•

confluenceUser •

Hi Anders, you are okay ?

In another cenario i´m to attempt to format output collumn in datalist with Bean sell script below:

String texto = String.format("%,.2f", value);

texto = texto.replace(",", "#");
texto = texto.replace(".", ",");
texto = texto.replace("#", ".");

return "<span style=\"color:green\">" + texto + "</span>";

------------------------------------------------------------------

But i´m getting this error message:

ERROR 07 Sep 2022 14:54:10 org.joget.plugin.enterprise.BeanShellFormatter - jwc_paulomnasc : Error executing script 9920 bsh.EvalError: Sourced file: inline evaluation of: ``String texto = String.format("%,.2f", value); texto = texto.replace(",", "#"); . . . '' : Typed variable declaration : Error in method invocation: Static method format( java.lang.String, java.lang.String ) not found in class'java.lang.String'

Observation: This code execute ok on java web editor www.jdoodle.com.

Any idea ?

1

CSV | Excel | XML | PDF

Your answer

Print

Failure to attempt to save a curency(money) value field

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-3118b652-cd53-4977-b764-9a41e0b829e4{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-1af2cfb0-a808-499a-a5a4-759d8f8c60a7{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer