> From: Jim Starkey [mailto:jas@...]

Hi,

> >Q1) Do the descendent tables use the same trigger, or do they
> get a new one
> >inherited from the one on the base table?
> >
>
> Ah! Smoke and mirrors! There is really only one actual table --
> the base table. The descendent tables are virtual -- views -- of
> the base table. Other than a little hackery to keep descendents
> of a different branch from firing (and probably a few other
> annoyances), the existing mechanisms all work. So the answer is:
> there is only one trigger on exactly one physical base table.

OK I think I understand this one (Just <g>).

In the Template method, descendant tables would get a new Physical Trigger,
and would contain Physical Fields for TIMESTAMP and DATE. This would allow
you to change the trigger in the descendant if required and/or change rename
the 'inherited' fields?

In the 'inheritance' method you describe, all descendant tables would share
the same trigger and same fields, so you could not change (override) the
trigger at a higher level, and you could not change the fields names/types
etc. either, you would have to do it at 'Base' level?

Cheers

Phil