At 09:35 AM 21-12-00 +1100, you wrote:

>I'm using tiCommitted as my transaction isolation. Got any more ideas??
>
>Thanks

What means did you use to commit the transferred data? If you didn't have
Autocommit true, you would need to call the transaction's Commit method and
handle any exceptions..

Also, inspect ibserver to see whether you have more than one connection,
e.g. you have your app running and you are running IB_WISQL (or some other
tool) as well, perhaps with a transaction open over the table or a
dependent table...

Helen

>-----Original Message-----
>From: Jason Wharton [mailto:jwharton@...]
>Sent: Friday, December 15, 2000 5:29 PM
>To: IBObjects@egroups.com
>Subject: Re: [IBO] Re: Record Lock
>
>
>Perhaps your transaction isolation is tiConcurrency? If so, you need to end
>and restart that transaction by calling Commit or Rollback and trying again.
>Or, you can change the isolation to tiCommitted.
>
>HTH,
>Jason Wharton
>CPS - Mesa AZ
>http://www.ibobjects.com
>
>
>----- Original Message -----
>From: <bituinb@...>
>To: <IBObjects@egroups.com>
>Sent: Thursday, December 14, 2000 10:38 PM
>Subject: [IBO] Re: Record Lock
>
>
> > Hi
> >
> > I'm merging two interbase database(same structure) using IBOObjects
> > v3.3.1 and Delphi4. When i access the converted data and try to
> > update some of the records that's been transferred from the source to
> > the target database, error is encountered "Can't update the record,
> > another user is using the record". (i'm the only one using that
> > database at that time).
> > Can anyone help me with this problem??
> >
> > thanks
> >
> >
> >
> >
> >
> >
>
>
>
>
>
>

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