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$(E-Mail Removed)>, "cbu"
<(E-Mail Removed)> writes:

>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?
>

You can use either SHORT, SMALLINT or INTEGER2.


--

Jon

www.applecore99.com - Access Tips and Tricks