Hi:

I am migrating a web site, from mysql to Sapdb.

This query, update the table suporte with some data.

UPDATE suporte 
   SET Categoria = 14, 
       Tecnico = 3, 
       Fechamento = '2003-03-08', 
       HoraFechamento = '17:58', 
       Solucao = 'Foi desligada a impresora e a maquina. Foi ligada a impresora
e a maquina.', 
       Finalizado = 1 
WHERE IdSuporte = 2

The field "solucao" is a LONG column.

In the Execution of this query, i get this error :

Error [SAP AG][SQLOD32 DLL][SAP DB]General error;
-7032 POS(137) SQL statement not allowed for column of data type LONG.

The manual say that "LONG columns can be used in the following SQL statements:

INSERT statement, UPDATE statement, NULL predicate, and in selected columns"

What is wrong in the syntax ?

Can you help me ?


Alejandro Michelin Salomon

PROBrax e-Tech

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to