[thelist] Coldfusion & MS Access SQL Resource Wanted

rudy r937 at interlog.com
Sat May 11 15:36:01 CDT 2002


>   ALTER TABLE ForumThreads
>   ADD NumberofViews INT
>   SET DEFAULT 0
>
> but i get errors saying invalid SQL syntax...
>
> so does Access set defaults in some wierd way?

not weird, just limited

only some ddl (data definition language) is supported, not all --

  HOWTO: Common DDL SQL for the
  Microsoft Access Database Engine (Q180841)
  http://support.microsoft.com/default.aspx?scid=kb;EN-US;q180841

you can alter the table to add an integer column, but you cannot set the
default value, and i believe it allows nulls even if you specify not null

do table design on your local database copy, and then upload

rudy




More information about the thelist mailing list