Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
RI from command window
I am in New York and the system is in Chicago. The power user in Chicago who administers the system has a copy of VFP. From the command window she has deleted records from a table that are referenced from another table. I am in the process of creating a Delete Trigger (actually a stored procedure called by the trigger) which will scan the other tables for references to the deleted record and reject the delete if busts RI. Things are working fine except that if I RETURN .F. when I detect a problem, I get a VFP error message about the trigger failing. I have my own message and I would like to stop the VFP message. I tried doing a RECALL and RETURN .T. VFP was not happy about the RECALL in the trigger.
I stuck an ON ERROR in the trigger. That does not fire. I am about to KEYBOARD a RECALL as I leave the trigger when the trigger wants to reject a delete. That strikes me as less than elegant.
Any thoughts?
Tim
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement