p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Alter Table - Add Column (http://p2p.wrox.com/showthread.php?t=2161)

liz@trinityholdings.co.za July 28th, 2003 09:16 AM

Alter Table - Add Column
 
Hi
Can anyone help. I am trying to use the 'Alter Table' statement to add a column to a table. The column I need to add is a Yes/No data type:

ALTER TABLE TargetSelect ADD COLUMN TransSelect Yes/No

Access doesn't seem to accept the data type 'Yes/No' so I just get a syntax error. Any suggestions?
Thanks
Liz



Bob Bedell July 28th, 2003 11:55 AM

Use the ANSI SQL data type BIT as in:

ALTER TABLE TargetSelect ADD COLUMN TransSelect BIT

(Yes/No is the Access SQL synonym for the ANSI SQL data type).

Bob

liz@trinityholdings.co.za July 29th, 2003 03:06 AM

Hi Bob
Thanks for your response. It worked well.
Regards
Liz




All times are GMT -4. The time now is 07:13 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.