Re: ADO error
- From: "Daniel Crichton" <msnews@xxxxxxxxxxxxxxxx>
- Date: Thu, 15 Jun 2006 13:16:50 +0100
kayal wrote on Thu, 15 Jun 2006 02:42:01 -0700:
"Incorrect syntax near the keyword 'COLUMN' statement(s) could not be
prepared. deferred prepare could not be completed"
can anyone please help me with this error which i get while trying to add
a column
to my table.
query "alter table release add column email varchar(2));"
It would help if you specified the database server you're using too.
Assuming MS SQL Server, your problem is that you've put "column" in the
statement - with ALTER TABLE ... ADD you just specify the column definition,
eg.
alter table release add email varchar(2)
Dan
.
- Prev by Date: RE: Query Excel 3.0 work***... not workbook
- Next by Date: Re: ROW-00001: Cannot allocate memory
- Previous by thread: RE: Query Excel 3.0 work***... not workbook
- Next by thread: Re: ADO error
- Index(es):
