Konrad Bloor wrote : >Hi there, >I wonder whether anyone can help. I'm trying to add a LONG VARCHAR column >to an existing table, and I can't get it to work. (Not in Oracle mode). >Consider an example in SQL Studio, where I set up this test table: >create table test ( >firstcol int, >secondcol varchar(20) >)
>If I try to add a long varchar to this table using the following expression: >alter table test add thirdcol long varchar >I get the following error: >Native error: -7032 >Text: [SAP AG][SQLOD32 DLL][SAP DB]General error;-7032 >POS(32768) SQL statement not allowed for column of data type LONG:THIRDCOL. >What I need to know is how to add an empty LONG VARCHAR column to this >existing table. I'd REALLY appreciate any pointers with this one. >Thanks, >K. You need at least MaxDB 7.4.03 for this feature. Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
