SELECT propnum FOR i = 1 TO ALEN(.aRemovePN,1) * delete the property number lnProperty = .aRemovePN(m.i) DELETE FOR nproperty = m.lnProperty ENDFOR>Would anyone have an idea to why this code runs so slow. I think I may not be removing records from a view correctly. I couldn't get the view to update unless I deleted the record directly from the table. It takes 7sec on 33000 records, 5sec on 10000 records.
> SELECT propnum > FOR i = 1 TO ALEN(.aRemovePN,1) > * delete the property number > DELETE FOR nproperty = .aRemovePN(i) > ENDFOR > SELECT view > REQUERY() >