Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set a deleted flag
Message
 
 
À
16/04/2009 18:00:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01395207
Message ID:
01395208
Vues:
58
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform