Jump to content
Joe Sansalone

TFDEventAlerter

Recommended Posts

Posted (edited)

Hi,

 

I'm using the TFDEventAlerter with a Subscription (Interbase) for any update, delete or insert

on a table.

The FDQuery has CachedUpdates set to True.  

 

It was working fine but then during testing, error:  "[FireDAC][Phys][IB]subscription transaction not found"

after an event was received from Interbase to notify of a change to the table.

 

Does anybody know WHY this would happen?

 

The first change to the table gets propagated correctly. The 2nd change results in above error.

 

Using Delphi 11. Connecting to remote Interbase 2017.

 

 

 

Edited by Joe Sansalone

Share this post


Link to post

It seems to be related to having another FDConnection - even though other connection

is not being used.  When other connection component is taken off the data module,

the FDEventAlerter successfully updates the FDQuery.

 

I just need to figure out why DELETEs are not being merged into the FDQuery???

Share this post


Link to post

Interbase 2017 server, with Change Views Generic sample Delphi 11

does NOT handle deletes properly.

 

But changing the server to IB2020 makes it work.

 

Any work around?

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×