|Subject||Re: [IBO] insertSQL Help please|
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 10:37 PM 8/03/2004 +0000, you wrote:both,
> >Why even use a trigger if you are using generatorlinks for all your
> >inserts? Or, why use generatorlinks if you are using a trigger? It
> >seems to me that you should only use one or the other, but not
> >or am I missing something?that the
> The trigger implements and enforces a business rule. It ensures
> table can get a PK, regardless of the interface that is used forinserts.
> It's a design mistake to assume that your application is the onlyone that
> will ever insert rows into the tables.know what
> In your particular applications, if you have reasons to want to
> the PK is, then you use generatorlinks. In the typical Delphiapplication,
> you *do* want to know, because updates, deletes and refreshes aredetail
> positioned on the PK; and because you often want to form master-
> relationships between sets inside the same transaction context.That makes sense. Thanks for the explanation.