Additional informaton re: VB6 Run-time error '-2147217887(80040e21)':
It seems when you execute VB6 Addnew it creates a blank record whose field
lengths are not the same as the underlying mySQL table, but rather are set
by the longest item of data in the field. For example,if I have a ZipCode
field defined as CHAR(10), but all the actual data in the table are 5
character zip codes, the empty record created by Addnew only allows a 5
character zipcode to be added. If you exceed that length, it gives the
above mentioned error, which relates to entering a string that is too long
for the field. If I change any single zip code in the underlying table to a
10 character version, then Addnew allows me to enter a new record with a 10
character zip code. So, Addnew seems to set its field lengths based on the
data in a table, not the table definition itself.
Is this a bug in mySQL, VB or what?