Thanks Sergey
I guess that explains it. Any ideas on how to accomplish what I need? How about triggering something when its recalled?


>AFAIK, you cannot update a table from within its delete trigger.
>
>>I am trying to write a stored procedure that will set a field tag to true when a record is deleted. The purpose being that records are frequently deleted and recalled but we want to know if it had been deleted at a previous time. My code
>>

>>function tagdeleted()
>>	delstatus = set('deleted')
>>	set deleted on
>>	replace wasdeleted with .t.
>>	set deleted &delstatus
>>endfunc
>>

>>fails with an error that says the cursor is readonly which is not true cause I can edit other fields without a problem. The function is called with a ondeleted trigger. Suggestions on what I'm doing wrong?
>>Thanks