As shown at the end of the message, I did define Keylinks, and they define
records uniquely (they are the prmary key fields)
It is joined and I have let IBO Querydesigner to define InsertSQL and
EditSQL.


Riho-Rene Ellermaa
senior programmer
Hansabank


You didn't supply Keylinks; or you supplied Keylinks that don't uniquely
identify the row.
Possibly a joined dataset that doesn't have its keylinks fully resolved...

rgds,
Helen

> > > > >
> > > Query:
> > > SELECT id,(select account from account a where
> > a.id=dom_pay.accid) as
> > > accountno
> > > , ACCID
> > > , STATUS
> > > , BBANK
> > > ...
> > > , VER
> > > , SIGN1
> > > , SIGN2
> > > , BANK
> > > FROM account
> > > join dom_pay on account.id=dom_pay.accid
> > > where uid=:UID and install=:INST
> > > for update
> > >
> > > KeyLinks:
> > > ID
> > > ACCID
> > > STATUS
> > >
> > > PessimisticLocking=true
> > > Keylinksautodefine =false (was true - same results)
> > >

[Non-text portions of this message have been removed]