How to Add a Field with Alert Table sentence?

[fineman]

Hi:
I want to Add a Field of short datatype using Alert Table sentence in
the a2k, but always error, someone can tele me why. thank you.

my SQL sentence:
Alter TABLE XTable Add Times short default(0)

 

[Douglas J. Steele]

AFAIK, "short" isn't a valid field type.

 

[fineman]

I changed into:
Alter TABLE [downcall] Add DownCallTimes integer default(0)

the problem still exist.

please.

 

[Graham R Seach]

ALTER TABLE [downcall] ADD COLUMN DownCallTimes INTEGER

But I'm fairly certain you can't use the DEFAULT operator with Jet. You'll
probably have to use DAO or ADO.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

I changed into:
Alter TABLE [downcall] Add DownCallTimes integer default(0)

the problem still exist.

please.

AFAIK, "short" isn't a valid field type.