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