front end: Visual Basic 6.0
Dim intAmount as integer
intamount = val(txtamount.text)
Back end: AS/400 db2
library: CPALLIB
field: amount
type: Numeric
Len: 9
Decimal: 2
value: 100000
The problem is that when i insert new record to my database for this field: (amount), the value is 100000. it returns runtime error -6 overflow.
Please help me..