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