Pitfall I ran into a while back.

IB_DataBase set for TiCommitted. Then thought it would be nice
to play with IB_Transaction and I hooked it up to then IB_DataSets and
all fell apart. Till I discovered IB_Transaction has its own
AutoCommit setting, which defaults to false :)

Best Regards,
Hans
===========================================================


Bituin Bautista wrote:

>
> I'm using tiCommitted as my transaction isolation. Got any more ideas??
>
> Thanks
>
> -----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
> >
> >
> >
> >
> >
> >
>