It's not possible with just a SQL Statement, but with java.sql. (found a page at last, with which I could search the mailinglist.. ;-) )
regards, Danny
Am Wed, 11 Jun 2003 10:46:25 +0200 hat Danny Tramnitzke <[EMAIL PROTECTED]> geschrieben:
Hi all
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
