RE: [PHP-DB] Re: MS Access - default value in create table
| From: | Andrew Hill | Date: | Thu, 25 Jul 2002 17:34:41 +0000 |
| Subject: | RE: [PHP-DB] Re: MS Access - default value in create table | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20787@lists.php.net to get a copy of this message | ||
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:pktoolkit@blizzhackers.com]
Sent: Wednesday, July 17, 2002 9:18 PM
To: php-db@lists.php.net
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" <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
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php