What is the isolation of the transactions?
This is an important factor when dealing with problems like this.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Rohit Gupta" <rohit@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, September 11, 2001 4:37 PM
Subject: Re: [IBO] TIBOQuery


> Jason,
>
> this happens even when you go silly over it
>
> Transaction assigned to the query has autocommit
> close the query first in case
> execute the sql,
> commit the transaction (not required)
> close the query (not required)
> kill the blasted query (not required)
>
> and still happens while the app is live. There are no limbo
> transactions in the database. the records are not visible to any
> other app... but inside this app the deleted records are still there.
> Its as if the query/transaction are just refusing to commit.
>
> This has happened on two apps... so this time we should be able
> to send you an example... but as soon as I get some spare time
> to do what I promised you, I get hit by another urgent problem. :-)
>
>
> To: <IBObjects@yahoogroups.com>
> From: "Jason Wharton" <jwharton@...>
> Date sent: Mon, 10 Sep 2001 23:39:46 -0700
> Send reply to: IBObjects@yahoogroups.com
> Subject: Re: [IBO] TIBOQuery
>
> > You are using two different transaction contexts. Either commit the
other
> > one prior to opening the second one or make them part of the same
context.
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
> > ----- Original Message -----
> > From: "Sandeep" <sandeep@...>
> > To: <IBObjects@yahoogroups.com>
> > Sent: Monday, September 10, 2001 9:50 PM
> > Subject: [IBO] TIBOQuery
> >
> >
> > > I'm using TIBOQuery to delete records.
> > > After deleting the records I open a form with TIBOTable. And if I try
> > > to edit anything in that table I get an exception saying Record
> > > locked.
> > >
> > > Any suggestions?
> > >
> > > Regards
> > >
> > >
> > > Sandeep
> > >
> > > Software Developer
> > > CFL
> > > sandeep@...
> > > http://www.cfl.co.nz