Try changing to

SELECT DOM_PAY.*,account.account, OWNER
from DOM_PAY
join account on account.id=dom_pay.accid
where status=2
and docdate<='today'
and uid=:UID
and install=:INST

Jason has sometimes told us to either use this explicit join syntax or use
JoinLinks (maybe this cause you the trouble), and I doubt you need for
update when you have specified EditSQL.

Set

At 16:38 23.03.2001 +0200, you wrote:

>SQL is
>
>SELECT DOM_PAY.*,account.account, OWNER
>from DOM_PAY,account
>where account.id=dom_pay.accid and
>status=2 and docdate<='today'
>and uid=:UID and install=:INST
>for update
>
>EditSQL is
>update dom_pay set status=:STATUS, sendstatus=:Sendstatus
>where ID=:old_id
>
>Editing and everything else worked fine until trying InvalidateBookmark().
>This call invalidates current record so I get back zeros for my fields data.
>
>Riho-Rene Ellermaa
>senior programmer
>Hansabank