Hi Hellen

Problem solved. Thanks for your help, you gave me enought to steer
me in the right direction. I found the Monitor Component by the
way...

The problem was I have 2 transaction components. 1 for editing, 1
for browsing. The browsing 1 set to autocomitt. The table
had 'switched' to the edit transaction. Restored it to the browse
one and its fine.

Thanks for your help

Darren

--- In IBObjects@y..., "Darren" <shy_fella23@y...> wrote:
> Sorry Helen?
>
> The Borland SQL Monitor will only show me BDE activitty won't it?
>
> I can't find a Interbase equivalent.
>
> Darren
>
> --- In IBObjects@y..., Helen Borrie <helebor@d...> wrote:
> > At 09:43 AM 06-09-01 +0000, you wrote:
> > >Hi Guys
> > >
> > >I have been using Interbase Objects for some time and suddenly a
> > >problem has
> > >popped up.
> > >
> > >I am using Delphi 5 Enterprise, Interbase 6 and IBObjects 3.6 Di.
> > >
> > >When I Commit a certain transaction the following error occurs.
> > >
> > >ISC ERROR MESSAGE:
> > >Dynamic SQL Error
> > >SQL error code = -504
> > >Cursor unknown
> > >
> > >STATEMENT
> > >TIBOInternalDataset: "ProductTable.IBOqrProductTable"
> > >
> > >The table 'ProductTable' is not in a transaction as it is never
> > >editied, but
> > >the table that has just been editied shares the same
> TIBOTransaction
> > >component.
> >
> > All open datasets are in a transaction, whether you edit them or
> not.
> >
> > What does the SQL Monitor show you at the point where this
> exception happens?
> >
> > Helen
> >
> > All for Open and Open for All
> > InterBase Developer Initiative · http://www.interbase2000.org
> > _______________________________________________________