At 03:01 PM 16-10-01 +0200, you wrote:

>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.

Presumably you have the pk's of all of the joined tables as the keylinks? IBO won't be able to make a LockSQL statement automatically, based on those, since the statement is
update aTable
set 1=1
where ThePK=:whatever_the_current_pk_is

viz. an update statement can apply to one and only one table...

So (assuming your edits only affect one table in the join) just make your LockSQL
update Your_KeyRelation_Table
set 1=1
where ThePK=:whatever_the_current_pk_is

Cheers,
Helen

>
>
>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]
>
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________