Subject RE: [IBO] Transaction question
Author Riho-Rene Ellermaa
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

> -----Original Message-----
> From: Svein Erling Tysv┬┐r
> [mailto:svein.erling.tysvaer@...]
> Sent: Friday, March 23, 2001 4:39 PM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] Transaction question
>
>
> If your SQL is simple and includes selection of your primary key,
> KeyLinksAutoDefine should be fine. Just guessed that turning
> it off and
> specifying something wrong in KeyLinks might cause trouble
> like the one
> you've described.
>
> Set
>
> >> What about KeyLinks?
> >
> >What about them?
> >
> >I have checkmarks in Keylinksautodefine and fetchfullrows
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-~>
> Get great low international calling rates
> from Net2Phone! Click Here!
> http://us.click.yahoo.com/fBRVBB/kJXCAA/4ihDAA/P0AVlB/TM
> --------------------------------------------------------------
> -------_->
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>