I suggest putting the column name in quotes.

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software  http://www.openlinksw.com
Universal Data Access & Virtuoso Universal Server 

-----Original Message-----
From: Nuttzy [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, July 17, 2002 9:18 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: MS Access - default value in create table

FYI, I'm sending this stuff through the odbc_exec command.  Any MS
Access
experts out there?

Thanks!
-Nuttzy

"Nuttzy" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to