> but it only seems to store the 1st one it reads

"bobnunny" <u17151@uwe> wrote in message news:59ac1c8e96b9c@uwe...
>I am trying to use a cursor to create a mass Text field with the results
>from
> the selections from a series of VarChar(8000) values. I know I need to
> use
> UpdateText, but it only seems to store the 1st one it reads. Can anyone
> help?
> Here's my text:
>
> Declare @TriggerText nVarChar(4000)
> Declare @ptrval Binary(16)
> Declare @Offset Int
>
> -- Create temporary table to hold Text field
> Create Table #tempTrigger
> (TextField Text NULL)
> Insert Into #tempTrigger Select ''
>
> -- Get Trigger "basis"
> Declare curTriggerBasis Insensitive Cursor For
> Select c.Text
> From sysObjects o (nolock)
> Inner Join sysComments c (nolock)
> On o.ID = c.ID
> Where o.Name = 'cttx_Customer'
> Order By ColID
> For Read Only
> Open curTriggerBasis
> Fetch Next From curTriggerBasis Into @TriggerText
> While @@Fetch_Status = 0
> Begin
> Select @ptrval = TEXTPTR(TextField),
> @Offset = DataLength(TextField)
> From #tempTrigger (nolock)
> UpdateText #tempTrigger.TextField @ptrval @Offset 0 @TriggerText
> Fetch Next From curTriggerBasis Into @TriggerText
> End
> Close curTriggerBasis
> Deallocate curTriggerBasis
>
> Select * From #tempTrigger (nolock)

Dan Guzman wrote:
>> but it only seems to store the 1st one it reads
>
>How are you determining this? What does 'SELECT DATALENGTH(TextField) FROM
>#tempTrigger' return?
>
>>I am trying to use a cursor to create a mass Text field with the results
>>from
>[quoted text clipped - 36 lines]
>>