I solved the missing KEYROWNUM problem - I had to define KeyLinks.

But the case DMLCacheing case 2 (different transactions and shared connection) still doesn't work.

I opened from my app one BPL module twice, so I had 2 similar grids on screen. The connection is using dbHandleShared, autocommit=true.
When I enter data into one grid and press Post, the other grid updates only after I refresh it manually.
As my Queries and Grids contain also lots of events I dropped another simple grid and similar select query into the same form. Surprisingly it refreshed OK?!?
But...as I opened 2 instances of the same form - inserting record into first instance updated 2. form ok, but inserting record into second form didn't refresh first form.

Curiouser and curiouser..

Is there anyone who actually uses DML cacheing in production?

Riho-Rene Ellermaa
senior programmer
Hansabank

> IBO 4.2Fp, BCB5
>
> 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 needs it?
>
>
> Riho-Rene Ellermaa
> senior programmer
> Hansabank
>