Can't create Integer field, a Long Integer is created instead?


C

cbu

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

Advertisements

J

JSand42737

"cbu" said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top