Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set a deleted flag
Message
 
 
To
16/04/2009 18:00:20
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01395207
Message ID:
01395208
Views:
57
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
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform