Decimal places not respected in Decimal field

Scriptcase 9 Bugs
#1

Steps to reproduce:

  1. Create a Decimal type field on any Form or Control app.

  2. Give it a precision of 2 decimal places.

  3. Switch ON Auto-complete with zeros.

  4. Try “accidentally” entering 1.567 (or any number with more than 2 decimal places). The field cannot handle it.

Valid responses should be either (a) ignore the extra decimal places and give 1.56 or (b) round the result to 1.57. But instead it gives 15.67 which is obviously wrong.

Notes:

There is no way to validate this so incorrect data gets entered into the form.

Changing the regional settings to switch the comma “,” and the full stop “,” does not fix the issue.

I will send an email to bugs@netmake.com.br

#2

Anyone interested in seeing this bug in action, you can use the sample form on SC website…

https://www.scriptcase.net/samples/php-form/editable-grid-view-modal/

Try entering 123.456 in the Credit Limit field. You will get $1234.56 instead.

#3

Yes same problem, the way decimal fields work is horrendous