Try this: ALTER table_name ADD COLUMN column_name column_definitions
Seamus At 01:56 pm 24/03/02 , you wrote: >I can't get the supposedly dirt-simple query below to work. Can anyone >see anything wrong with my SQL? No matter what I do I get this error: > >ODBC Error Code = 37000 (Syntax error or access violation) >[Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE >statement. > >The field adds fine in other platforms (different SQL of course); adds >fine if used in a CREATE TABLE where all other fields in the table are >defined at once, but won't work no matter what I alter below. > ><CFQUERY DATASOURCE="#request.NewDSN#" DBTYPE="ODBC" NAME="MakeTable"> >ALTER TABLE cm_users ( >ADD UserName text(10) NULL >); ></CFQUERY> > >Any ideas would be greatly appreciated. > >--Matt Robertson-- >MSB Designs, Inc. >http://mysecretbase.com > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
