TOraAlerter - Several Events within one transaction

aebibueb · Post by **aebibueb** » Mon 20 Oct 2008 14:21

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

Plash · Post by **Plash** » Thu 23 Oct 2008 13:34

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.

aebibueb · Post by **aebibueb** » Thu 23 Oct 2008 13:46

will do asap, thanks for the reply...

cheerio

aebibueb · Post by **aebibueb** » Thu 23 Oct 2008 15:33

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...