Hello Michael, please use a prepared statement for the update of the long value, and supply the value for the LONG ASCII column as parameter, as using literals in UPDATE commands if LONG columns are affected is not supported.
Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Michael P. [mailto:[EMAIL PROTECTED] > Sent: Monday, April 25, 2005 1:48 PM > To: List > Subject: update of long > > Hi, > > how can I update a column of type Long. I only need unlimited > text-comments to be updated, no files - within a Visual Basic.net > application. I can't find any hint in the MaxDB documentation. I'm > looking forward to your answer. > > Best, > Michael > > Details: > > CREATE TABLE mytable > ( > id Integer NOT NULL, > comment Long ASCII, > PRIMARY KEY (id) > ) > INSERT INTO mytable SET id = 20, comment = 'this and that' > UPDATE mytable SET comment = 'this and that 2' WHERE id = 20 > > The latter sql command leads to the error 'General > error;-7032 POS(30) > SQL statement not allowed for column of data type LONG'. > > > > > > -- > 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]
