Thanks Lester. That makes sense. I wrote an after update trigger
almost like the one you listed in your email and made sure I made it
ACTIVE. Then I wrote some code under a button:

IB_Connection1.Connect;
IBOQuery1.Open;
IB_Events1.RegisterEvents;

and then added this to the Event_alert event:

ShowMessage(AEventName);

But after I manually update a record, nothing happens. I listed the
event in my IB_Event component. What might be wrong?

--- In IBObjects@yahoogroups.com, Lester Caine <lester@l...> wrote:
> ra8009 wrote:
>
> > I don't understand what events I can register and use with IB Events.
> >
> > My challenge is that when one user modifies a record in a particular
> > table, I need to have other users views immediately refreshed. Is this
> > possible with IB_Events? Which event do I register?
>
> The one's you create ;)
> You need to create triggers in the database which detect exactly what
> changes you want the 'world' to know about ( it does not happen
> automatically ;) )
>
> CREATE TRIGGER NEWTRIGGER FOR CALLING
> AFTER UPDATE
> POSITION 0
> AS
>
> BEGIN
> POST_EVENT "CALL_UPDATE";
> END
>
> so you register to receive "CALL_UPDATE"
>
> I have more complex triggers that just give - say - "TRAIN_ARRIVED"
> so you can do what ever you want :)
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
> Treasurer - Firebird Foundation Inc.