Sergey
There are from 1 to maybe 100 items at given times in the array. Most of the time there is only 1. thisa particular time there is only 1, that is why I am concerned this app may die if the array hits 50. there is an index on nproperty as a PK. This function runs when a record is canceled. I use the array to keep a pointer to the number that the user canceled so that I can reset my nextid table back to the correct nextid number.

>Chuck,
>
>Do you've index on 'nproperty'? How many items are in .aRemovePN array in each case?
>
>>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()
>>