front end: Visual Basic 6.0
Dim intAmount as integer intamount = val(txtamount.text)
Back end: AS/400 db2
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..