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.
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!