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
> >
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

Regards

Rohit

======================================================================
CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand
PH (649) 489-2280
FX (649) 489-2290
email rohit@... or r.gupta@...
======================================================================