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]



Reply via email to