I am reading a TBD(To be determined) table from SQL server. My code works for records 1- 32766, then starting at record 32767, I get an overflow error at here:
intTBDID = recTBD("TBD_ID").
intTBDID is declared as integer, and TBD_ID in the SQL table is integer.
I understand it is the value greater than what TBDID can have. but it is an integer, and 32767 is not that huge number. Where should I look for the cause?
I am using VB6, and slq 2000.
Any help is great! Thank you.