|Subject||Re: Trigger propagation across databases|
> It is possible to affect content in other databases inside atrigger ?
From my understanding, no. Triggers, stored procedures, etc. can
only work within the context of their own database.
The only way to connect to multiple databases is via your client app
(IBConsole does this).
I imagine what you would do here is have your client app use an event
notification ('Programming with database events' in devguide.pdf) and
respond accordingly -- in this case by connecting to the other dbs
and making the required changes.
You're not simply talking about replication are you? If so,
IBreplicator will handle any replication situation you care to throw
--- In ib-support@y..., "Entrebytes S.L." <ebytes@t...> wrote:
> Hi , ppl.
> The Need : To be able to link tables of different databases so a
change in a
> table fireup a propagation of changes to the tables of the same
> other databases , but only if this table is marked as "shared" ,
> do it when the "shared" state changes.
> Thanks in advance.
> EntreBytes S.L.
> Ontenient , Spain
> ERP Development.