I have a problem with updating a Table with a LONG BYTE Column.
So when I want to insert an image-File in HEX into that Column, it's no problem (any more ;) ).
For that I can take the following Statement :
INSERT INTO <tab name> (<long spalten name>) values (x'ffd8ffe000104a46494600010101004800 ...')
You see, that 'x' is needed to insert HEX Values.
But now I want to make an UPDATE on that Table, but the Statement
UPDATE <tab name> SET <LONG BYTE Column> = x 'ffd8ffe000104a46494600010101004800 ...' where ID = 1
Doesn't work. Also when I just want to UPDATE that HEX without the 'x' , there comes the Error :
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-7032 POS(24) SQL statement not allowed for column of data type LONG.
I hope that tells me not, that there is no possibility to update LONG Columns...
I use the newest Version of SQL Studio and sapdb kernel
Best regards, Danny
-- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
