Thanks Hilmar, I have used the stuff from your article and actually have it working on this table (although the delete tag has no code). For simplicity sake I would like the tag to be located in the primary table rather than the audit table. Any thoughts on triggering the tag upon recall?
>I would suggest to implement an audit trail that records ALL changes done by users, to any table, to a separate audit table - who did what change, and when.
>
>See my article for the general idea, and some simple sample code that can help you get started. Universal Thread Magazine, May 2003, "A Basic Audit-Trail".
>
>>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