Overflow error

[zzz8611]

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.

[crptcblade]

32766 is the limit for and Integer. Go with a Long instead, it can hold upwards of 2 billion+.

[seaweed]

Originally posted by zzz8611
it is an integer, and 32767 is not that huge number

I don't know what you mean, that it's not that huge number. It is the max value for an integer in VB (although a SQL integer will hold a value up to 2,147,483,647)!

You need to use a VB datatype that supports a larger number, such as a long.

[radum]

our sweet vb uses 2 bytes to represent variables declared as Integer, so the max positive value is 32767. sql server uses 4 bytes to represent what it calls an 'int' variable, so the max positive value in there is 2smth bilions. what that means is that vb and sql have different opinions about what an 'integer' is. to correct this, use long variables in your vb application to host integer datat types in sql.

[zzz8611]

I thought VB is the same as sql. Now it works! Thanks again.

[radum]

ntz. vb is like noooo-thing else.