want to change field size by using alter table

  • Thread starter Thread starter frustrated
  • Start date Start date
F

frustrated

I am using
dbs.Execute "alter table tabname add column SW number"
which works fine BUTTTTT, it adds the column with a field
size of long integer and I NEED it to be 'integer' -- how
can I change this?????

I need an answer ASAP as a project depends on this

Any help you give will be GREATLY appreciated.
 
Back
Top