I'ts also set to autocommit=True. Actually, after i transferred the data
using IBO, I then start
8 threads (creating TQuery & Tdatabase) to update all the links of the
transferred data (primary key changes when i transferred it so i have to
re-link the foreign key that it references), each thread has it's own
database connection and handles only particular table. After a thread
terminates , i start again another thread to handle another table (max of 8
theads running).
I'm merging 1.2G database as the target database and 500MB souce database.

thanks,



-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Thursday, December 21, 2000 9:44 AM
To: IBObjects@egroups.com
Subject: RE: [IBO] Re: Record Lock


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
_______________________________________________________