--- In IBObjects@yahoogroups.com, Aage Johansen <aagjohan@o...> wrote:

> On Thu, 4 Dec 2003 16:46:49 +0000 (UTC), bjorgeitteno wrote:
>
> > ...
> >> ...
> >>> The error:
> >>> When I start 2 instances of this application with the same

user name,

> I get
> >>> the "deadlock" error when closing app nr. 2. No matter if it

was started

> >>> first or last. I am fairly sure all writings to table

USER_SETTINGS is

> >>> committed immediately.
> >>
> >> How do you verify that the commit occurs? Are you *really*

calling Close

> >> on the transaction instead of a hard commit?
> >
> > No. I call a Commit;. and I've been able to track execution into

the

> > xxx.IMP file. I do not call 'Close'. An explicitly started

transaction.

> >
> >>> I know the problem is within writing the last table, because

the error

> >>> doesn't appear if I write to another record here.
>
>
>
> Hi Bjørge!
>
> Can you update+commit the record from another app (e.g. IB_SQL)

after

> closing the first app (before closing the second)?
>
>
> --
> Aage J.