>>>I'm trying to only keep the first unique value of the GroupHeading field, blanking all others like it until I get to a different value. The code below is kicking out of the DO WHILE because the value of GroupHeading is changed by the REPLACE. I understand why, but how can I get around it?.
>>>
>>> SELECT WorkListXMLCursor
>>> SCAN
>>> m.GroupHeading = GroupHeading
>>> DO WHILE GroupHeading = m.GroupHeading
>>> SKIP
>>> REPLACE GroupHeading WITH ''
>>> ENDDO
>>> ENDSCAN
>>>
>>
>>why not replace GroupHeader with "" for GroupHeader = m.GroupHeader ?
>
>I'm sorry, but that makes no sense to what I'm trying to do.
>
>I start with this in the first field (there are others not listed here):
>
> 1 RECEIVER
> 2 RECEIVER
> 3 RECEIVER
> 4 SUBSCRIBER
> 5 SUBSCRIBER
> 6 SUBSCRIBER
> 7 SUBSCRIBER
> 8 DEPENDENT
> 9 DEPENDENT
>10 DEPENDENT
>11 DEPENDENT
>12 DEPENDENT
>
>And want this:
>
> 1 RECEIVER
> 2
> 3
> 4 SUBSCRIBER
> 5
> 6
> 7
> 8 DEPENDENT
> 9
>10
>11
>12
>
I had a similar requirement recently. In other words, you want to update all records except for the record with the minimum record number, correct?
If so, this can be done in one UPDATE statement. Give me a sec.
If it's not broken, fix it until it is.
My Blog