On Fri, May 30, 2008 at 5:01 PM, Rafael Copquin <rcopquin at ciudad .DO.T com.ar>
wrote:
> I confess I never used triggers or RI with VFP tables. I would rather use
> my own logic and code whatever is needed to achieve the same result.
>
------------------------------------------
Triggers are great for doing secondary things when a change is made. At the
data level you can capture the change, evaluate if that change is what you
are trying to deal with.
Case in point I have data that is necessary to build a pre-manufactured data
table used for a display later on in our process. I have to manufacture
line #s to an order that do not exist as well as fkeys to point to other
tables.
Because this is all data, and data rules I use triggers to do it, and not
bring that data up to another engine for processing.
------
> Another reason is that I prefer to have full control over my code, so I
> write my own routines to deal with referential integrity.
> ------------------------------------
I have full control of the code, sql or C# no matter. I am writing it.
--
Stephen Russell
Sr. Production Systems Programmer
Mimeo.com
Memphis TN
901.246-0159
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
©2008 Stephen Russell |
