Subject DML Caching (take 2)
Author Riho-Rene Ellermaa
First message seems to be disappeared.

IBO 4.2Fp, BCB5

I'm trying to implement DML caching to my banking app. The application consists of several BPL modules that all share one IB connection.
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.

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?

Riho-Rene Ellermaa
senior programmer