Hi group,
the definition of a table with a field of type long with the default
value '' such as
>>>
CREATE TABLE "DBA"."A_PERSON"
(
"ID" Integer NOT NULL,
"NAME" Char (20) ASCII DEFAULT '',
"COMMENT" Long ASCII DEFAULT '',
PRIMARY KEY ("ID")
)
<<<
works fine. However, if I like to add a field of type long with a
default value such as
>>>
ALTER TABLE "DBA"."A_PERSON" ADD ("COMMENT2" LONG ASCII DEFAULT '')
<<<
the error
>>>
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-7035 POS(32768) DEFAULT specification not allowed for
this column:COMMENT2
ALTER TABLE "DBA"."A_PERSON" ADD ("COMMENT2" LONG ASCII DEFAULT '')
<<<
occurs. What's wrong with the alter statement? I use SqlStudio7.5 and
MaxDB-Version maxdb-all-win-32bit-i386-7_5_00_26.
Thanx for help.
Michael
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
