How to Add a Field with Alert Table sentence?

  • Thread starter Thread starter fineman
  • Start date Start date
F

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)
 
I changed into:
Alter TABLE [downcall] Add DownCallTimes integer default(0)

the problem still exist.

please.
 
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
---------------------------

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

the problem still exist.

please.


Douglas J. Steele said:
AFAIK, "short" isn't a valid field type.
Click to expand...
Click to expand...
 
Back
Top