TZPgEventAlerter

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
sfxcc
Senior Boarder
Senior Boarder
Posts: 95
Joined: 13.05.2010, 18:48

TZPgEventAlerter

Postby sfxcc » 02.11.2013, 23:50

How works TZPgEventAlerter because i cant do it work ?
Can you help me with a simple example.
where's the code ..

sfxcc
Senior Boarder
Senior Boarder
Posts: 95
Joined: 13.05.2010, 18:48

Re: TZPgEventAlerter

Postby sfxcc » 05.11.2013, 20:04

Any on please , does this component works at all???
where's the code ..

sfxcc
Senior Boarder
Senior Boarder
Posts: 95
Joined: 13.05.2010, 18:48

Re: TZPgEventAlerter

Postby sfxcc » 06.11.2013, 01:36

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

markus
Senior Boarder
Senior Boarder
Posts: 55
Joined: 17.10.2011, 12:43
Location: Piotrków Trybunalski, Poland

Re: TZPgEventAlerter

Postby markus » 09.11.2013, 14:58

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
Senior Boarder
Senior Boarder
Posts: 95
Joined: 13.05.2010, 18:48

Re: TZPgEventAlerter

Postby sfxcc » 11.11.2013, 21:00

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,
where's the code ..

markus
Senior Boarder
Senior Boarder
Posts: 55
Joined: 17.10.2011, 12:43
Location: Piotrków Trybunalski, Poland

Re: TZPgEventAlerter

Postby markus » 13.11.2013, 11:20

sfxcc wrote: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
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 29.09.2016, 11:39

Re: TZPgEventAlerter

Postby kjm » 29.09.2016, 11:49

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
Gold Boarder
Gold Boarder
Posts: 589
Joined: 17.01.2011, 14:17

Re: TZPgEventAlerter

Postby marsupilami » 13.10.2016, 19:08

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


Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest