General error;-1002 POS(1) Too many columns

Hello!

i have a small table with one pk integer column and 4 varchar columns
and want to issue the following alter statement to add a new column:

	alter table my_table add ("delete_record" smallint)

if the table both is filled or empty i can not add the column. i always 
get the error message:


---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Not Committed
General error;-1002 POS(1) Too many columns
alter table my_table add ( "delete_record" smallint )

whats wrong with that statement?

thx, chris

-- 
the version of the database is 7.5 running at suse linux...



-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]