I have an "InsertNewEmplo yee" function which has quite a few parameters
in its INSERT statement. When I call the ExecuteNonQuery method, I get
an OleDBException overflow exception.
Any idea what gives?
I checked the string lengths for the record to be inserted that's
failing, and none of them are over the length limit in the Access
database I'm using. The two integer parameters aren't overflowing
either. So it's not that.
Could it be the sheer number of parameters? I have over twenty. Or,
could it be the EmployeeID (auto-numbered) field, which I'm NOT
referring to in my insert statement?
Help...
Damon
in its INSERT statement. When I call the ExecuteNonQuery method, I get
an OleDBException overflow exception.
Any idea what gives?
I checked the string lengths for the record to be inserted that's
failing, and none of them are over the length limit in the Access
database I'm using. The two integer parameters aren't overflowing
either. So it's not that.
Could it be the sheer number of parameters? I have over twenty. Or,
could it be the EmployeeID (auto-numbered) field, which I'm NOT
referring to in my insert statement?
Help...
Damon