I have a routine that needs to process unique id's from a table. This table odten has a deleted record for the ID as well as the possibility of multiple records for that ID.

What it does is run a:

SELECT DISTINCT bm_recid from bmdata to array arrBMid

Then I step through the array manipulating the data as needed.

for arrCtr=1 to alen(arrBMid)
  goto arrBMid(arrCtr)

  ---- process record ----

endfor

The problem is it is pulling the DELETED record if it is there and NOT going to the subsequent record for that ID that is NOT deleted.

I finally realized what it was doing and tried a SET DELETED ON before all this to stop that problem... that doesn't work and I thought it should.