Hello.
I added a new column to a table and I made a reference to another table. And when I tried to add a value in the column I received this error.
Best answer by Robbert van Tongeren
View originalHello.
I added a new column to a table and I made a reference to another table. And when I tried to add a value in the column I received this error.
Best answer by Robbert van Tongeren
View originalIn that trigger (goods_receipt_line_tu) on line 47, there is something that cannot be converted to a int. That is the location you should be looking at.
I would guess the problem is that the INT you are tying to insert is getting larger then 2147483647, which is the maximum for an int. If you need to go bigger you should be using a BIGINT.
Or maybe the calculation for adding up is not correct which results into a large number.
Can you check on the database it self?
I do think you have a update trigger on the “goods_receipt_line” :)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.