Bug or my error? MariaDB - using decimal (10,2) returns error on insert or update

Scriptcase 9
#1

Hello everyone,

I have decimal (10,2) fields in MariaDB database. When I create batch application and just run it, it returns error:
image

My DB looks like this:
image

Is it my mistake or is it bug or should I do it differently?

Thank you for your help!

#2

I think your statement Insert can be incorrect… try change the value for first and third field to ZERO.

#3

the way i debug such things , you copy sql script and run in in the database directly, you might get more clear error indication. your fields may not accept null values , or you try to use wrong decimal separator. inputing decimals is really nightmare in scriptcase, for whatever reason, like Excel way should be standard, but in SC it is just creasy IMHO.

goodluck

#4

Thanks a lot! I figured out that I mistaken Choose ‘,’ (comma) instead of ‘.’ (dot).

1 Like