Hi, I have problem to add column with default value and LONG column to a table. My table is: create table bug_add_columns (ch char (20)) I try to add two columns - one varchar column with default value and one LONG column. alter table bug_add_columns add ( ch1 VARCHAR (80) DEFAULT 'def_val' null , cl LONG null ) when executing this statement with SQL Studio error occured:
--------------------------- error --------------------------- Database error occured: Native error: -807 Text: [SAP AG][SQLOD32 DLL][SAP DB]Communication link failure;-807 Connection down, session released. --------------------------- OK --------------------------- and SAP DB service stops. if I change type of column with default value or change default value error occured again. if I remove default value - all is OK. if I add only first column with default value - all is OK I am using: Kernel 7.4.3 Build 010-120-035-462 Runtime environment W32/INTEL Build 010-120-035-462 SQL Studio 7.4 SQLSTUDIOODBC 7.04.03.00 Milen Manev -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ Bitte l�cheln! Fotogalerie online mit GMX ohne eigene Homepage! _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
