Subject RE: [IBO] Transaction question
Author Svein Erling Tysvær
Try changing to

SELECT DOM_PAY.*,account.account, OWNER
from DOM_PAY
join account on
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.


At 16:38 23.03.2001 +0200, you wrote:
>SQL is
>SELECT DOM_PAY.*,account.account, OWNER
>from DOM_PAY,account
>where 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