TZPgEventAlerter

[sfxcc]

How works TZPgEventAlerter because i cant do it work ?
Can you help me with a simple example.

[sfxcc]

Any on please , does this component works at all???

[sfxcc]

I think this is becuase zeos alwasy have a transaction started so it cant receive pgevents....
Im i correct or is missing some thing ?

[markus]

Hi,
this component does work:)
but you must remember that only one of this components can actually receive notifications from database (that's pg_notify design).
So try with only one PgEventAlerter in your app, aor if you use more of them - assign Processor component to them so you will always have one "main" notification processor.

Best regards,
Marek

[sfxcc]

Im using Pg 9 and i cant do it work i do events='removed';active = true after connection up and on postgres trigger ondelete procedure i do notify removed;


Its not working. can someone check this. I use Pg9 x64 and x32 libs.

Thanks,

[markus]

Im using Pg 9 and i cant do it work i do events='removed';active = true after connection up and on postgres trigger ondelete procedure i do notify removed;


Its not working. can someone check this. I use Pg9 x64 and x32 libs.

Thanks,

You also need to assign Connection to your event alerter component (if you haven't done it yet).
It would be easier if you posted some simple code of how you use TZPgEventAlerter.

Best regards,
Marek

[kjm]

Hi,
I have the same Problem. I created a trigger event in my database table for update and insert and called it myEvent.
In lazarus I assigned Connection and Events to the component but active is still false.
I would need a simple tutorial or example to imagine, how it works. Is there a possibility to receive all (!) notifications
in the componnent for testing ?
Greetings
K. Müller

[marsupilami]

Hello kjm,

could you please put together a small test case? A small application for Delphi or Lazarus and a database script would be good. Could you also please test the current version of Zeos 7.2 from the SVN?
With best regards,

Jan