Re: Error executing sql statement

Try;

ALTER TABLE mytable ADD myfield text(x)

(where x = the string length)

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Ivan Debono" wrote:
| Hi,
|
| I'm executing the following SQL statement using ado 2.8:
|
| ALTER TABLE mytable ADD myfield text DEFAULT('')
|
| And get the following error:
| Microsoft JET Database Engine (3320) Missing ), ], or Item in table-level
| validation expression.
|
| I don't see anything missing. What the problem then?
|
| Thanks,
| Ivan
|
|


.

Relevant Pages

  • Re: Error executing sql statement
    ... ALTER TABLE mytable ADD myfield text ... Dave Patrick ....Please no email replies - reply in newsgroup. ... "Ivan Debono" wrote: ...
    (microsoft.public.access.queries)
  • Re: Programmatically test field existence
    ... alter table mytable add myfield n ... Dan ...
    (microsoft.public.fox.programmer.exchange)
  • Error executing sql statement
    ... I'm executing the following SQL statement using ado 2.8: ... ALTER TABLE mytable ADD myfield text DEFAULT ... validation expression. ...
    (microsoft.public.access.queries)
  • Re: Programmatically test field existence
    ... if you want to test the existence of "Myfield" field in "Mytable" table and ... alter table mytable add myfield n ...
    (microsoft.public.fox.programmer.exchange)