topic Re: numerical overflow in Application Development and Automation Discussions

numerical overflow

former_member739940 — Mon, 17 May 2021 15:54:03 GMT

I have a field in my sql database which has a data type of Decimal(2, 2). The problem is when I try to insert data i.e. 5 or -5 in this field I get dberror (314) which is numerical overflow. I don't know why I'm getting that error.

Re: numerical overflow

jonel_rienton — Mon, 17 May 2021 15:59:31 GMT

Hi, try increasing the size of the column to Decimal(10,2). Thank you.

Re: numerical overflow

jonel_rienton — Mon, 17 May 2021 15:59:54 GMT

Hi, try increasing the size of the column to Decimal(10,2). Thank you.