I don't use DML myself, but a couple of thoughts.

> I'm trying to implement DML caching to my banking app. The application consists of several BPL modules that all share one IB connection.

Do they need to share one connection? Are you still having
to using Interbase, because I find that this sort of thing
works a lot better with additional connections for some
tasks.

> One case is were there are two users working with the same module (generating payments). This I got to work - one user does something and other users grid is updated OK.
> The problem case is were 1 user prepares some payments (shown in grid) and then from menu launches another module that sends these payments to bank and updates their statuses (STATUS="SENT").
> It worked when one user viewed payment module and other user sent data to bank, but when 1 user did all, then no updates were visible.

How is the refresh of information being generated? I had
something similar, where the other operators saw a change,
but I had not refreshed locally and it was not seeing the
global message ( NOT using events - this is just a thought).

> Next I set the UpdateQuery's dcfAnnounceEdit=true, but now I get error "KEYROWNUM field is not found" when I try to post my status change. It's true that I don't have such fields in my tables, but who wants it?

I can't help there, but hopefully someone with a few more
grey cells can step in <g>

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services