Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I ??
Message
From
23/08/1999 14:44:45
 
 
To
23/08/1999 14:43:12
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00256680
Message ID:
00256710
Views:
19
>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
Map
View

Click here to load this message in the networking platform