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
