Richard Kaye wrote: > What is it you're trying to accomplish? Simply preventing all deletions? > If that's the case, since deleting is not forever in VFP, why does it > matter that the delete trigger fires after the record is deleted. > Couldn't you just recall the record in the trigger? >
I had a situation where some sort of snafu/bug was causing records to be deleted during a TABLEUPDATE gone awry. As of 3:30am this morning, I've now fixed the bug (I think!) but this question was posted as a "safety valve" way to absolutely ensure that even if the TABLEUPDATE() fowled up, the records didn't get deleted. -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.