Developer Forum

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?

In article <00d601c3d14f$80a870d0$ XXXX@XXXXX.COM >, "cbu"
< XXXX@XXXXX.COM > writes:


You can use either SHORT, SMALLINT or INTEGER2.


Jon

www.applecore99.com - Access Tips and Tricks