>>>>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.
And I do not want to change the order of any of the records. Not that that likely matters in an UPDATE statement. AND, there could be another set of SUBSCIBER records below DEPENDENT.