General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Bruce,
>
>I'm pretty sure if you return and .F. from a delete trigger you will get the default message box.
>
>When the delete trigger fires, the record is already marked for deletion. How about just recalling the record from within the delete trigger UDF? Then you can return .T. indicating the trigger worked, and you and VFP will be happy.
>
>regards,
>
>Jim
>
>>I know how to create my own UDF and place it in the DELETE TRIGGER for a table. It tests for child records and IF FOUND(), throws up a messagebox() w/ an OK button. However, when I RETURN .F. to the TRIGGER in order to prevent the delete, I still get the VFP generated messagebox() w/ "Trigger Failed". How can I return a false value yet suppress the VFP message ? Or, am I going about this all wrong ??
>>Any help would be appreciated.
You can't update the cursor from within a trigger. I just tried the recall.
Previous
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