I'm using ado statements to pass values to my stored procedures.
for instance
myado.Parameters.Append myado.CreateParameter("Autonummerbusbeperking", adInteger, adParamInput, 4, lngAutonummerbusbeperking)
lngAutonummerbusbeperking is declared as a long value and fetches an autonumber.
The access data-type integer is only 2 bytes with a max value of 32000.
I've specified adinteger with size 4, will it really work until 2^31 value or is it an access data type?
for instance
myado.Parameters.Append myado.CreateParameter("Autonummerbusbeperking", adInteger, adParamInput, 4, lngAutonummerbusbeperking)
lngAutonummerbusbeperking is declared as a long value and fetches an autonumber.
The access data-type integer is only 2 bytes with a max value of 32000.
I've specified adinteger with size 4, will it really work until 2^31 value or is it an access data type?