I am using the C/C++ precompiler of SAP DB 7.3.0.46 and want to update the data of a LONG column.
I recognized that if the new value is shorter than the old value, the updated column has the length of the old value, and the value is the new value plus the part of the old value that is longer than the new value.
I can reproduce this behaviour with the appended program. The program creates a table X with columns k INTEGER and f LONG BYTE. It then inserts a row with k=1 and f='HELLO' and finally updates the row with f='BELL'. If I query the table, I get the value 'BELLO' for column f.
Regards,
CTB -- _______ \o/|\o/ Claus-Thomas Buhl | Diplom-Informatiker \_____/ mailto:[EMAIL PROTECTED]
H.E.I. GmbH | Wimpfener Strasse 23 | D-68259 Mannheim Fon: +49-(0)621-795141 | Fax: +49-(0)621-795161 | mailto:[EMAIL PROTECTED] http://www.h-e-i.de && http://www.hei.biz && http://www.radpage.com
updatelongcolumnwithshortervalue.tgz
Description: application/compressed-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
