Vernon wrote
> I get an error "-7032 SQL statement not allowed for column of datatype
LONG"
> when I issue the following SQL statement "UPDATE AAATEST (TEST2) VALUES Y
('qwertyu')".
> I can update any of the other columns in the table except the one of type
LONG.
> Can you not update a LONG column?
You can but you have to use parameter/hostvariables.
A long update with literals is not supported by sapdb.
This is a JDBC example from an older mail on this list:
(see http://sapdb.icf.net/cgi/talk-inhalt.html?such=LONG~UPDATE&id=9726)
PreparedStatement UPDATE = conn.prepareStatement ("UPDATE tablename set
LONGcol = ? where keycol = ?");
UPDATE.setAsciiStream (1, someInputStream);
// or insert.setString (1, stringvarWithLONGContent);
UPDATE.setString (2, keyValue);
UPDATE.executeUPDATE ();
HTH.
Kind regards,
Holger
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
