RE: Error 7032

Lorenz, Hr. wrote:
> 
> Hi all,
> 
> i've tried to update a long-value in a table with this command:
> 
> UPDATE MyTable SET MyText='Just three words' WHERE 
> TextDate='2003-09-08
> 10:46:40'
> 
> and all I get is an error -7032 (not allowed for LONG).
> The manual said I can use UPDATE on LONG-Fields, but maybe my 
> syntax is not
> correct.

According to docs:
The update statement can only be used to assign a value to columns with the data type LONG if it contains a parameter or NULL specification. The assignment of values to LONG columns is therefore only possible with some database tools.

And:
UPDATE for LONG-columns is not allowed if more than one row has to be updated with a non-NULL-value for that LONG-column

Elke
SAP Labs Berlin

> What am I doing wrong?
> 
> Greetings
> 
> S. Lorenz
> 
> 
> 
> _______________________________________________
> sapdb.general mailing list
> [email protected]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>