Re: Easiest way to prevent deletion of records in a VFP9 DBC table

Hey Michael. I'm not sure if I could be of help here as I rarely use the DBC, but could you create trigger on the deletion for that table and always return .F. ? -Kevin CULLY Technologies, LLC Sponsor of FoxForward 2007 foxforward.net MB Software Solutions wrote: Is there a way to

Re: Easiest way to prevent deletion of records in a VFP9 DBC table

Kevin Cully wrote: Hey Michael. I'm not sure if I could be of help here as I rarely use the DBC, but could you create trigger on the deletion for that table and always return .F. ? I rarely use the DBC events and triggers too (although I must say that I love the

Re: Easiest way to prevent deletion of records in a VFP9 DBC table

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? MB Software Solutions wrote: I

Re: Easiest way to prevent deletion of records in a VFP9 DBC table

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

Re: Easiest way to prevent deletion of records in a VFP9 DBC table

That's a bird of a different feather... g How about wrapping that TABLEUPDATE in a transaction, too? MB Software Solutions wrote: 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

Re: Easiest way to prevent deletion of records in a VFP9 DBC table

Richard Kaye wrote: That's a bird of a different feather... g How about wrapping that TABLEUPDATE in a transaction, too? Yepgood idea...but as of this AM, I rewrote it to simply SCAN the view for the dirty buffer records, did a SEEK to find the matching record in the table, then did a

Easiest way to prevent deletion of records in a VFP9 DBC table

Is there a way to short-circuit a delete operation at the database level? iirc, the Delete Trigger only fires AFTER a row is deleted. -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software

Easiest way to prevent deletion of records in a VFP9 DBC table

Is there a way to short-circuit a delete operation at the database level? iirc, the Delete Trigger only fires AFTER a row is deleted. -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software