Re: MS Access - default value in create table
| From: | Nuttzy | Date: | Thu, 18 Jul 2002 02:18:03 +0000 |
| Subject: | Re: MS Access - default value in create table | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20612@lists.php.net to get a copy of this message | ||
FYI, I'm sending this stuff through the odbc_exec command. Any MS Access
experts out there?
Thanks!
-Nuttzy
"Nuttzy" <pktoolkit@blizzhackers.com> wrote in message
news:20020715183059.9842.qmail@pb1.pair.com...
> I can create tables and perform alterations just fine. However, if I try
to
> specify a DEFAULT value in either CREATE TABLE or ALTER TABLE, it craps
out
> on me. For example, this works....
>
> ALTER TABLE phpbb_mytable
> ALTER COLUMN LastName TEXT(40)
>
> ...but this doesn't....
>
> ALTER TABLE phpbb_mytable
> ALTER COLUMN LastName TEXT(40) DEFAULT Unknown
>
> ...even though I believe this is the correct syntax. Same thing happens
for
> CREATE TABLE. Help!!!
>
> Thanks,
> -Nuttzy
>
>