Page 1 of 1

TOraAlerter - Several Events within one transaction

Posted: Mon 20 Oct 2008 14:21
by aebibueb
Hi there

I am using the TOraAlerter in our application and it works great. However,
I do have the problem that when I am sending two events within one transaction (one commit), then my client only receives the first one. The next one is "swallowed" by the Alerter in the following statement:

procedure TOraAlerter.AfterExecute(Sender: TObject; Result: boolean);
=> WaitSQL['Name'] = 'mymessage2' // this is correct, the 2nd message of the commit
=> WaitSQL['Message'] = '__ODAC_Terminate_Event__'

I don't quite know what to make of this. Either I'm using it wrong (in which case sorry about that) or then the Alerter is terminating too early?

Just to make it clear, the alerter does get both events I'm sending ("mymessage1","mymessage2"), it only does a notify for the first one though.

Thanks for any insight on this, cheerio
christophe

Posted: Thu 23 Oct 2008 13:34
by Plash
We could not reproduce the problem. Please send to odac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

Posted: Thu 23 Oct 2008 13:46
by aebibueb
will do asap, thanks for the reply...

cheerio

Posted: Thu 23 Oct 2008 15:33
by aebibueb
ok i'm deeply sorry i missed a point in our code.... i thought (again, really very sorry!) the alerter was active all the time, but unfortunately it got deactivated in the event-handler and then that was it naturally....

sorry guys, really sorry. i was positive i had checked that (i even had specific debug code for that), but obviously i hadn't...