Fiel ntext whit UpdateText

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank Dulk (fdulk_at_bol.com.br)
Date: 12/15/04 

Date: Tue, 14 Dec 2004 22:35:16 -0200

would like to update a field of the type ntext, but all register them that
are in a select.

I tried the code below, but he only updates the last record:

CREATE PROCEDURE SPU_EtiquetasRevBaixar
@pDataEnvio AS NVARCHAR(10),
@pEtiqueta AS NVARCHAR(255),
@pStatus AS INT
AS

DECLARE @Msg AS BINARY (16)
DECLARE @MsgAtu AS NVARCHAR(255)

SET @MsgAtu = @pDataEnvio + ' - ' + @pEtiqueta + Char(13) + Char(10)

SELECT @Msg = TEXTPTR(tbl_Cliente.Observacoes) FROM tbl_EtiquetasRevTemp
INNER JOIN tbl_Cliente ON (tbl_EtiquetasRevTemp.Codigo =
tbl_Cliente.Cod_Cliente)
WHERE (tbl_EtiquetasRevTemp.Status=@pStatus)
UPDATETEXT tbl_Cliente.Observacoes @Msg 0 0 @MsgAtu
GO

Relevant Pages

  • Re: byte inversion in ciphertext
    ... it'll similarly register the revision. ... televisions characterise, pronounce, and declare. ...
    (sci.crypt)
  • Re: Dynamic call of SP with out parameters from another SQL SP
    ... DECLARE STMT VARCHAR; ... DECLARE P1 INT; ... DECLARE MSG VARCHAR; ...
    (comp.sys.ibm.as400.misc)
  • Re: How to compile the following into a DLL?
    ... what might give it the ability to register itself in the registry. ... I've created a small ActiveX dll using VB and the file is only ... the module export thing depends on the assembler and linker used, ... use a definitions file to declare them but with the right tools ...
    (comp.lang.asm.x86)
  • Re: a little help please
    ... declare @URCLASS smallint ... print @msg ... declare role_crsr cursor for ... fetch role_crsr into @name, @password ...
    (comp.databases.sybase)
  • Re: incr initialization (was: Hecl)
    ... limited to given stack-frames or namespaces. ... for current stack-frame, and "register" given variables. ... If some later code in that stackframe does [lappend newVar foo], ... call "declare" in its procedures and thus not be affected ...
    (comp.lang.tcl)