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 ?
LONG columns in UPDATEs are only supported through PreparedStatements, bound parameters or whatever they're called in the programming language you're using.
So replace all the values in your statement with quotation marks and look up in your SQL API how to set parameters at runtime.
Daniel Dittmar
-- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
