RE: Error 7032

Hello,

the use of literals (strings like 'mytest', or hex literals like x'0A0B0C') is in some commands
not allowed. You have to use a prepared statement and bind a parameter in the programming language
you use. 

Take not also, that literals are of limited use for LONG types, as the length of literals is limited
to the length of ordinary columns (approx. 8K).

Alexander Schröder
SAP DB, SAP Labs Berlin 

> -----Original Message-----
> From: Lorenz, Hr. [mailto:[email protected]]
> Sent: Monday, September 08, 2003 11:07 AM
> To: [email protected]
> Subject: Error 7032
> 
> 
> 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.
> What am I doing wrong?
> 
> Greetings
> 
> S. Lorenz
> 
> 
> 
> _______________________________________________
> sapdb.general mailing list
> [email protected]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>