General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only