Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I ??
Message
From
23/08/1999 14:43:12
 
 
To
23/08/1999 13:36:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00256680
Message ID:
00256709
Views:
22
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.
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.com

No trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform