Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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.
Précédent
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