Using VB6 to add a new field of type Integer with
following command text:
"ALTER table <table name> ADD COLUMN <New field name>
INT" ( also tried using "INTEGER instead of just 'INT'"
This always creates the new field as a LONG INTEGER and I
don't know why. I use "ALTER table <table name> ADD
COLUMN <New field name> LONG" to create a long integer
field, but I just want the size to be the smaller of the
two ('Integer' type).
How can this be done?